using vb to change row height for a whole worksheet
 

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.

using vb to change row height for a whole worksheet
 

It should be

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

If this post helps click Yes
---------------
Jacob Skaria


"NDBC" wrote:

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.

using vb to change row height for a whole worksheet
 

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

Thanks.

"Jacob Skaria" wrote:

It should be

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

If this post helps click Yes
---------------
Jacob Skaria


"NDBC" wrote:

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.

using vb to change row height for a whole worksheet
 

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
---------------
Jacob Skaria


"NDBC" wrote:

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

Thanks.

"Jacob Skaria" wrote:

It should be

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

If this post helps click Yes
---------------
Jacob Skaria


"NDBC" wrote:

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.