View Single Post
 
Old 01-13-2017, 11:58 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Found is not an address, it's a range.

I have no idea what your code in red is supposed to be doing.
I'd suggest you insert this line immediately ahead of the red code
Code:
Stop
Then use the F8 key to step through the code one line at a time.
Hover your mouse over the various variables to see if they are what you expect.
Reply With Quote