View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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