View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
iris iris is offline
external usenet poster
 
Posts: 12
Default 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.