thanks Lewis, i like the InStrRev, good to know that exists. I found this as well:
and also, which i ended up using:
so now my code works... but only if I step through it... I'm trying to build an image painter which loops through every pixel of a selected image, and changes an individual cell to that pixel's color. don't ask why...
at least once in my tests i was able to click on the button, select an image and it painted just fine, but repeating that process a second time usually seems to paint all cells grey. closing the workbook and trying again seemed to fix the issue yesterday but it does not today... if i step through the code however, everything looks like it's working. i spent about 5 minutes painting one line at a time earlier (by adding a break to the next i line) and got halfway through an image, then i removed the break, hit f5 and the window froze for a few minutes, then moved on through the code as if it was working (but it had painted the remainder of the image grey again...)
any thoughts? workbook attached.
Bookmarks