Hi all,
I have a block of data in columns AH to AM.
What I want to do is delete any rows which contain a "0" as the cell value in column AK, with VBA.
Note I don't want to delete the entire row, just the selection across AH to AM (similar to "shift cells up" type manual operation).
Any ideas?
Bookmarks