Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row height
Hi,
I want to use the range below and then check each row in that range for row height, if the row height is = to 12.75 or less then I want to change the row height to say 11.75 and all other rows in the range leave as they are. Range("A101", Range("End") range name ("End") is in column A Thanks James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
row height
Hi
then you have to loop through all rows. and check each individually -- Regards Frank Kabel Frankfurt, Germany "James Montgomery" schrieb im Newsbeitrag ... Hi, I want to use the range below and then check each row in that range for row height, if the row height is = to 12.75 or less then I want to change the row height to say 11.75 and all other rows in the range leave as they are. Range("A101", Range("End") range name ("End") is in column A Thanks James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
row height
Frank I tried this but it changes all the rows to the new height
For Each row In Range("A101", Range("End").Offset(0, 0)) If RowHeight <= 12.75 Then row.RowHeight = 11 End If Next row can you help James "Frank Kabel" wrote in message ... Hi then you have to loop through all rows. and check each individually -- Regards Frank Kabel Frankfurt, Germany "James Montgomery" schrieb im Newsbeitrag ... Hi, I want to use the range below and then check each row in that range for row height, if the row height is = to 12.75 or less then I want to change the row height to say 11.75 and all other rows in the range leave as they are. Range("A101", Range("End") range name ("End") is in column A Thanks James |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
row height
Hi
try something like the following: dim irows as long with activesheet for irows=101 to .Cells(Rows.Count, "A").End(xlUp).Row if .rows(irows).rowheigth = 12.75 then .rows(irows).rowheigth = 11 end if next end with -- Regards Frank Kabel Frankfurt, Germany "James Montgomery" schrieb im Newsbeitrag ... Frank I tried this but it changes all the rows to the new height For Each row In Range("A101", Range("End").Offset(0, 0)) If RowHeight <= 12.75 Then row.RowHeight = 11 End If Next row can you help James "Frank Kabel" wrote in message ... Hi then you have to loop through all rows. and check each individually -- Regards Frank Kabel Frankfurt, Germany "James Montgomery" schrieb im Newsbeitrag ... Hi, I want to use the range below and then check each row in that range for row height, if the row height is = to 12.75 or less then I want to change the row height to say 11.75 and all other rows in the range leave as they are. Range("A101", Range("End") range name ("End") is in column A Thanks James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set a minimum row height a the same time with autofit row height | New Users to Excel | |||
Row Height stopped growing and Auot-Fit Row Height does not work | Excel Discussion (Misc queries) | |||
the row height should be excatly the height of the data | Excel Discussion (Misc queries) | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
Set new row height based on current height | Excel Programming |