Hi Guys,
Basically, I have a table of data and I want to make a VBA coding so that Any row with "cell value = 0 in column C" will be deleted.
But i can't get my code working and i don't know why. There's no error pop up either.
Please Help,
Thanks guys.
Please Login or Register to view this content.
Difficult to say without seeing in the context of its workbook.
But before going down the looping macro, step back a bit. This question really should be a FAQ. I see it time and time again and looping just isn't the best way of doing this sort of thing. Loops should only be used as a last resort since they can be very slow when many rows are involved.
The fastest way I know of doing this is to use an autofilter starting at C11 and filter for blanks. Then select all the filtered rows using the .SpecialCells(xlCellTypeVisible) construct and delete them all, finally removing the filter.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Doesn't look anything wrong with the code ... unless row 309 is actually the last row of data and there are no gaps in the data.
Maybe try:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks