Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all:
Looking to adjust row heights of a 185 row w/sheet. First I use: Rows("4:184").RowHeight = 12.75 I expect this should work quickly and efficiently. I don't quite know what to do with the "exceptions" rows. I could use: Rows("6:6, 9:9, 14:14, 18:18, 24:24, 30:30, ETC......").RowHeight = 3.75 But there are over 30 rows that need to be referenced. The double row references become cumbersome and don't really add to the clarify of the code. I'd like to use something like: SRow = Short Rows Short Rows = (6, 9, 14, 18, 24, 30, etc........) Then: SRow.Row Height = 3.75. If something like this can be done, I think it would be "easier" to read and also to adjust, if and as required. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Turn off auto adjust of row heights | Excel Worksheet Functions | |||
Creating a Macro to adjust the row heights | Excel Programming | |||
Excel: copy grid, widths & heights down page: heights wrong! why? | Excel Discussion (Misc queries) | |||
Copying Row Heights, or Complete Rows | Excel Programming | |||
Return Row Heights for Rows in Active Worksheet - an example | Excel Programming |