can someone give me a little push here? I've tried all the breaks I can with this code and checked vars that have values in the immediate window and I can't seem to get why the worksheet object is not being set and transacted. It's been a while since I've written legacy VB like this, so I'm sure it's probably something very simple. Here is my code:
the code fails on the first line of the loop:
every var returns a val in the immediate window if I break it on the error line except the worksheet object. Can someone spot my misstep? thank you so much.
Adam
Bookmarks