I've tried to find if this has been handled before in this forum, but no luck. My simple program:
loops through a column of data and hides the row of any gray cell in that column. The problem is that the gray cells are grayed due to conditional formatting. Instead of reading the .ColorIndex property as "15", it reads it as "-4142", regardless of the cell's actual background color.Please Login or Register to view this content.
Is there a way around this?
Bookmarks