Determining if certain row # is blank
One way:
Dim bLine8IsBlank As Boolean
bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0
In article ,
Bob wrote:
I would greatly appreciate any help in writing the necessary line(s) of code
to determine if a given row (e.g., 8) in the active workbook is completely
blank.
Thanks,
Bob
|