autofit row by VBA

[ashani]

Hi,

I wonder if someone could please guide me in the following situation in VBA:

- In my workbook I have approx 100 worksheets and I would like to autofit row "U30:U300" based on the data in there with wrap text and column width remains 53.

I want that to apply in all 100 worksheets in the same Rows.

Please can someone help me with this.

Many thanks,

 

[rlv01]

Why not use the macro-recorder to record a macro of yourself doing whatever kind of 'autofit' you are talking about to just one worksheet and post it here. Then we can see about how to extend it to 100 sheets.