Delete Row if Cell Contains Value

[ptmuldoon]

I'm trying to search column A from the bottom up to delete an entire row if the cell contains the "Customer/" header info.

However my code below keeps deleting all rows?

Please Login or Register  to view this content.

Ideally, I will need this once working to delete both that row where "Customer/" is found as well the 2 rows above and 2 rows below, which I think I can do with an offset as well?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ptmuldoon]

Thanks John

But unfortunately that code didn't seem to delete the rows. I know its possibly to try and filter the data for the "Customer/" header row and delete those visible cells/rows. But do you know if possible after the filter to also delete the 2 rows above and 2 rows below that header row using an Offset as well?

I'm gonna do some google searches and work some more on it today as well.

Thanks

[JOHN H. DAVIS]

Can you attach a sample file. To me it seems would be ackward working on filtered cells. I think the best way would be using a loop somehow from bottom to top. But if the code I suggested doesn't work, I think attaching a file with some sample data to test may be helpful in finding a solution.