View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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