Determining if certain row # is blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 24 Sep 2007 17:44 GMT

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

Reply to this Message

Gary Keramidas - 24 Sep 2007 18:05 GMT

this should return a zero if the row is blank:

application.counta(rows(8))

Signature

Gary

>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

Reply to this Message

Bob - 24 Sep 2007 18:28 GMT

Gary - Thanks!

> this should return a zero if the row is blank:
>
[quoted text clipped - 4 lines]
> > Thanks,
> > Bob

Reply to this Message

JE McGimpsey - 24 Sep 2007 18:09 GMT

One way:

Dim bLine8IsBlank As Boolean
bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0

> 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

Reply to this Message

Bob - 24 Sep 2007 18:28 GMT

JE - Thanks!

> One way:
>
[quoted text clipped - 6 lines]
> > Thanks,
> > Bob

Reply to this Message