Is there a way to use find or similar to locate, say, the first cell in row 1 where cells.interior.colourindex=4 ?
Basically, I have to define ranges in 1000+ sheets and the ONLY things that are constant across all the sheets that I can use as a starting point are that the top left cell has the same background colour and they all start on row 1. The contents are different, the cell addresses are different, the ranges won't be the same size...
If you have a better idea as to how to start and/or if the formatting search definitely doesn't work, please let me know. This is all I've been able to come up with so far.
Bookmarks