| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change row height | Excel Programming | |||
| Change height of row | Excel Discussion (Misc queries) | |||
| How do I change row height to 16.0? I get choice of 15.6 (26 Pix. | Excel Discussion (Misc queries) | |||
| how do you change a row height in a protected worksheet | Excel Programming | |||
| UserForm Change Of Height | Excel Programming | |||
Linear Mode
