Find a row with a given value in column A and delete all rows belo
 

I have written a VBA procedure to import a text file, format it. Now I need
to add the capability to check for a value in column A. When I find that
value, I then want to delete that row and all other rows below that row, all
from within the VBA procedure.

Find a row with a given value in column A and delete all rows belo
 

Turn on the macro recorder and then do Edit=Find and search for your target
value. then turn off the macro recorder and look at the recorded code.

Then add the line
Range(activeCell,"A65536").entireRow.Delete

--
Regards,
Tom Ogilvy



"DDK" wrote:

I have written a VBA procedure to import a text file, format it. Now I need
to add the capability to check for a value in column A. When I find that
value, I then want to delete that row and all other rows below that row, all
from within the VBA procedure.