Hello: I can not for the life of me figure this out. I have even switched the loop to go from Last row to 2 (starting from bottom up) and no matter what I do my loop ends before it is done. I'm not sure if it has to do with the delete nature of the command?
Background: I'm cleaning up a large set of data. I've provided a small sample to illustrate my problem.
The first loop appears to work flawlessly. The first loop scrolls through and shifts any cell containing ":" to the right. Next I want to scroll through Column C and remove and shift cells to the left for cells with text containing "photo". This second loop never makes it to the end. I have tried re-defining the last row, ranges, etc. Would anyone have any brilliant ideas?
I've attached the sample spreadsheet for you with the VBA code.
Original sample data is on one tab and you can see where the code ends in Column C on the Cleaned Up data tab.
Hopefully this makes sense.
Thanks,
Stef,
Bookmarks