Thread: Find empty rows or columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Find empty rows or columns
application.CountA(rows(3)) = 0

would indicate it is empty

--
Regards,
Tom Ogilvy


"Marvin" wrote in message
...
What is the best way to determine if a row or column is empty?

Thanks.


Reply With QuoteReply With Quote