View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shirley Munro
 
Posts: n/a
Default Deleting results of an AutoFilter excluding top row


Hi

I am recording a macro which performs a series of task. One of these
tasks is to filter out all the cells which are blank in column C. Once
the filter has been applied, I want to delete all the rows containing
blanks in column C with the exception of row A which contains my
headings.

Any suggestions would be much appreciated.

Shirley Munro


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=507651