Determining if certain row # is blank
 

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

Determining if certain row # is blank
 

this should return a zero if the row is blank:

application.counta(rows(8))
--


Gary


"Bob" wrote in message
...
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

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

Determining if certain row # is blank
 

JE - Thanks!


"JE McGimpsey" wrote:

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

Determining if certain row # is blank
 

Gary - Thanks!

"Gary Keramidas" wrote:


this should return a zero if the row is blank:

application.counta(rows(8))
--


Gary


"Bob" wrote in message
...
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