Find empty rows or columns
 

What is the best way to determine if a row or column is empty?

Thanks.

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.

Find empty rows or columns
 

select the whole worksheet from the upper-left square, then go to Data, Sort
Data, select whether that collumn has a header or not, then select the column
to be sorted. You will shove any potential data to the top or bottom of the
column.
--
Acknowledge and Move on.


"Marvin" wrote:

What is the best way to determine if a row or column is empty?

Thanks.