Code runs in debug mode only.

Hi all,

the code below runs fine in debug mode but stops at:

Please Login or Register  to view this content.

with error message Run-Time Error 91 Object Variable or with Block variable not set. When trying to run through in one go

Please Login or Register  to view this content.

any idea's what maybe causing this at all please?

EDIT: it's ok solved the issue grr was an error in the TARGET_CELL.Offset(0, COLUMN_COUNT - 1).Value

Hi Kramxel,

I've seen this when opening other files and it simply takes some OS time to perform the action. When you step through the code, there is time for the OS to do the work but when the code runs, lines of code fire before they are supposed to. To allow the OS time to do its work I've added some DoEvents code in my code which allows these other things to happen before trying to fire more lines of code. I use a lot of DoEvents when using SendKeys in my VBA code.

All the above being said, I haven't examined your code fully to see where a DoEvents might be needed (if at all), but the question sounds like this answer might be correct.