using vb to change row height for a whole worksheet

[NDBC]

I have created a new workbook using vb and now I am trying to change the row
height for the entire sheet "results" to 15.75. My code does not seem to work.


wbNew.Sheets("Results").Select
Selection.RowHeight = 15.75

Thanks for the help.

 

[Jacob Skaria]

It should be

wbNew.Sheets("Results").Rows.Rowheight = 15.75

If this post helps click Yes

 

[NDBC]

Thanks Jacob. I had just worked it out and was going to post it up but you
beat me yet again.

Thanks.

 

[Jacob Skaria]

Oh..Good.. Thanks for your feedback..

I have responded to your other post on 'Selecting range using row and column
number addresses' which I hope would be useful.

If this post helps click Yes