software

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: www.excelforum.com/member.php...nfoamp;userid=836
View this thread: www.excelforum.com/showthread...hreadid=507651Before the filter set a range like so

Set rng = Range(Range(quot;A2quot;), Cells(Rows.Count,quot;Aquot;).End(xlUp))

then after the filter, do

rng.SpecialCells(xlCellTypeVisible).Delete

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Shirley Munroquot; gt;
wrote in message
news:Shirley.Munro.22luly_1138888801.7238@excelfor um-nospam.com...
gt;
gt; Hi
gt;
gt; I am recording a macro which performs a series of task. One of these
gt; tasks is to filter out all the cells which are blank in column C. Once
gt; the filter has been applied, I want to delete all the rows containing
gt; blanks in column C with the exception of row A which contains my
gt; headings.
gt;
gt; Any suggestions would be much appreciated.
gt;
gt; Shirley Munro
gt;
gt;
gt; --
gt; Shirley Munro
gt; ------------------------------------------------------------------------
gt; Shirley Munro's Profile:
www.excelforum.com/member.php...nfoamp;userid=836
gt; View this thread: www.excelforum.com/showthread...hreadid=507651
gt;