Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height
could there be a formatting or rounding issue? Is there a pattern for
certain row heights that are being reported as 0? "Steve" wrote in message ... : Help. : : Running this macro the results are unexpected. : : For rowscount = 1 To 200 : If Worksheets(usingsheet).Cells(rowscount, "G") = True Then : Worksheets(usingsheet).Cells(rowscount, "I") = : Rows(rowscount).RowHeight : End If : Next rowscount : : The purpose of this code is to enter in cell on Column I the height of the : row, but only if the cell in column g is TRUE. : : 75%ish of the entries that should have a value are coming out as zero. The : fact that a zero is entered in the cell means that it is evaluating : correctly, but not reading the correct row height. : : This is causing me a headache, so any assistance would be appreciated. : |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Height
Solved it by changing the macro command to:
Worksheets(usingsheet).Range("I" & rowscount).Value = Worksheets(usingsheet).Rows(rowscount).RowHeight I don't know why, but it now works correctly Strange!! "PaulD" wrote: could there be a formatting or rounding issue? Is there a pattern for certain row heights that are being reported as 0? "Steve" wrote in message ... : Help. : : Running this macro the results are unexpected. : : For rowscount = 1 To 200 : If Worksheets(usingsheet).Cells(rowscount, "G") = True Then : Worksheets(usingsheet).Cells(rowscount, "I") = : Rows(rowscount).RowHeight : End If : Next rowscount : : The purpose of this code is to enter in cell on Column I the height of the : row, but only if the cell in column g is TRUE. : : 75%ish of the entries that should have a value are coming out as zero. The : fact that a zero is entered in the cell means that it is evaluating : correctly, but not reading the correct row height. : : This is causing me a headache, so any assistance would be appreciated. : |
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) | |||
need to dbl row height without changing height of cell next to it | New Users to Excel | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
resize row height and column height | Setting up and Configuration of Excel |