I wonder if somebody could help me with the following:
My current worksheet has a 5000 data records.
I would like a VBA macro to perform the following actions on this data list:
... Go to the column header that says: 'Hyperlinks_Paths' (Column Headers are located in the first row)
... go down one cell so that the first cell right under the Column Header 'Hyperlinks_Paths' is the beginning of the range
... Set a range that spans down to the last filled cell in that column
... Insert a hyperlink (C:\MyFolder\DummyGraphic.png) in all the cells which have the following cell shading: RGB (222, 222, 222). Existing cell contents in these cells is to be overwritten with this Hyperlink text.
Help is much appreciated.
Thank you very much in advance for your professional help.