I need to change the Font Color Index of a Range even if the rows are hidden by a Filter.
My Code is:
The code works perfect except when some of the rows are hidden by a Filter. I have many filters on many columns and cannot remove them. Is there any way to change the Font Color Index of a Range even if some of the rows are hidden by a filter?![]()
Range("C1:C300").Font.ColorIndex =7
Bookmarks