Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Each Row from there to here"?
I'm trying to set my row height if it's less than a certain height. The
code worked fine on the whole sheet, but errors out when I try to constrain it to my used range. At the "For Each rw" line, I get a syntax error: compile error. When it was "In Worksheets("Sheet1").Rows", it worked fine, but did all my blank rows and my header, too! Suggestions are appreciated. Ed Sub TestRowHeight() Dim FirstRow As Long Dim LastRow As Long FirstRow = 2 LastRow = Range("B65536").End(xlUp).Row For Each rw = LastRow To FirstRow Step -1 If rw.RowHeight < 25.5 Then rw.RowHeight = 25.5 End If Next rw End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |