I need to delete the row if there is a date (any date) in column J. My current code is only deleting one row then stopping and leaving the rest... what is wrong?
Please Login or Register to view this content.
I need to delete the row if there is a date (any date) in column J. My current code is only deleting one row then stopping and leaving the rest... what is wrong?
Please Login or Register to view this content.
you can not use For Each c In .Cells because when you delete a row cells counting fails
Please Login or Register to view this content.
Last edited by patel45; 09-28-2012 at 01:09 PM.
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks