HI,
I have a check-clearing routine that reads the bank's list of cleared checks and then searchs a sequential list of check numbers from the GL to mark them "cleared". I would like to start the next search in the loop at the point of the last "found" check, rather than starting at the top of the O/S check list each loop.
I tried saving Activecell.Address to a variable, then calling Range(mVar).Activate at the top of the loop. This give an 'object variable' error. What am I doing wrong?
I have a check-clearing routine that reads the bank's list of cleared checks and then searchs a sequential list of check numbers from the GL to mark them "cleared". I would like to start the next search in the loop at the point of the last "found" check, rather than starting at the top of the O/S check list each loop.
I tried saving Activecell.Address to a variable, then calling Range(mVar).Activate at the top of the loop. This give an 'object variable' error. What am I doing wrong?