View Single Post
  #5   Report Post  
Old July 6th 19, 02:48 PM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,788
Default Identify rows if in the row one of the cells within a range is colored

Hi again,

Am Sat, 6 Jul 2019 15:46:09 +0200 schrieb Claus Busch:

For Each rngC In .Range("B3:BZ3")
If rngC.Interior.ColorIndex = xlNone Then rngC.EntireColumn.Hidden = True

sorry typo.
Change the first line to

For Each rngC In .Range("F3:BZ3")

Claus B.
Office 2016