Hello,
I have the below code in a file. The file has a summary tab followed by a number of tabs that may change over time which come out of an accounting system in csv which isn't the cleanest format. The code does a reverse search for a number of different text items. Once it finds the one furthest up in the data i then selects the cell right above it and deletes all rows from that cell up. The macro works perfectly if I run it on a sheet by itself. As soon as I wrap loop code around it it debugs at the LastRow = .Range at the bottom of the code. I have change the code various times. Some versions of the code it will before but then debugs on ActiveCell.Offset where it performs the code on the one tab but then stays on that tab and performs it again causing it to bomb out because you can't offset -1 from cell A1. It should move to the next tab and run the code. It doesn't see to be doing that. Any help would be appreciated.
Bookmarks