Macro looping

Hi all,

I'm using the following Macro to delete all rows that have a cell containing USD in a column range from F6 to F5000. The macro works but it only deletes a row at a time when run. Can anyone tell me how get this to loop through all rows until the end?

Thanks (Excel 2003)

Please Login or Register  to view this content.

Check out this example

Delete rows on criteria

Click the Reset button to populate Column A

stjohnsmythe
when hiding rows it best to loop in reverse order so the row numbers not hidden

Please Login or Register  to view this content.

I would use AutoFilter, automate it with VBA if necessary

Roy has suggested the correct approach

Please Login or Register  to view this content.

I had trouble posting back yesterday.

I would actually automate AutoFilter to do this. Dave has an example in his workbook, but it needs some changes.

The button won't work because there is no data to filter on the page containing the button. The sheet to work with needs referring to in the code. Also, ScreenUpdating needs switching back on at the end, I usually add an error handler to make sure.

Please Login or Register  to view this content.