I would like to create a named range on the worksheet "DATA" of the current workbook based on cell fill color.
The macro is to search for the "first" (C15) and "last" (G32) occurrence of red filled cells (RGB 230, 184, 183) …
… and create a workbook-level scope with that range (C15:G32)
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.