Hi

I am recording a Macro which carries out various procedures on a file
which is downloaded weekly and in which the number of rows various.
One part of the macro is to run an If Statement in column G which once
generated I want to copy down the remaining active cells in column G
which varies each time the file is downloaded. Is there any way I can
get the results of the If statement only to fill down active rows or do
I need to copy it the whole length of the worksheet and then delete all
the surplus rows.

Thanks

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=509950