Thread: Identify rows if in the row one of the cells within a range is colored
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
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
Next

sorry typo.
Change the first line to

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


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote