Originally Posted by
alansidman
Ok. I got it figured. You are looking to post to the last row +1 in column A. Since there is nothing in column A, the macro is writing over the data into the same location - row2 which is the last row +1 in column A.
Change it to look at column B for the last row.
You would have seen this happen if you debugged your macro by stepping through the lines of code. If you are unsure about that, look at this video. He talks about debugging at about the 3 minute mark.
Alan
ok after doing some reading,debugging (thanks Alan), and moving some data around, I used
Thanks for the help Alan!
Bookmarks