I have a huge macro that I delete various rows based on criteria, it's always worked but for some reason now all the sudden on of them only deletes one row, instead of all visible rows.
Steps work up until the delete row, which it only deletes the top row instead of all visible.
See attached example. It's filtering AG for blanks and deleting.
Here's the code (also included in the file)
I know it's something simple but it's weird because I have this same macro in my file 6 times and all previous 5 work for other columns..but this one doesn't.Please Login or Register to view this content.
I suspect it might be because when these blanks appear, all the next columns are also blank so maybe it's only selecting the first row of data, thinking the data is ended..so there must be be a diff way to delete all visible rows based on column A (which always has data)?
Thanks in advance!
Edit:
Would this be the best solution?
Please Login or Register to view this content.
Bookmarks