Hello,
I am attempting to find a variable string in a range and then putting a formula in the cell 6 columns over. The entire process is in a loop so that the variable will change and a different cell will be found each time. The first iteration works perfectly, the second always bugs out with a Run time error 91: Object variable or With block variable not set.
I tried every combination of things I could think of, I hope someone here can help.
I am taking data from one workbook to another, so the data goes into destWS in destWB (destination). Data is copied to lines sequentially in destWS, so I have a destRow that tracks which line gets filled next and then adds 1 each iteration.
The Find code originally omitted activating cells and all that, but I changed it in hopes of it working and this is what's left. I cut out a lot of code above and below because it hopefully isn't related.
I'm hoping it's a simple quirk about find or objects that I don't know.
Thanks for your help!
Bookmarks