Change this code so it appends text to a cell that is highlighted.

I found this code that identifies a cell that is filled with background color and then highlights the column header it is in. How can i change this so it appends text to the front of the cell that is shaded instead. So if the cell is yellow and says "Automotive" in it, after running the script it would say something like
"**CHANGED** - Automotive"

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

Hi,

Perhaps the following immediately before the loop's 'Next' instruction

Please Login or Register  to view this content.

Thanks but this is changing the column header. To be clearer I need to find any highlighted cell on the sheet and then change that specific cell and not the headers. I included this code b/c it was the only thing i could find that was close to what I was looking for.

Hello BeaglesBuddy,

If I've understood your request correctly then the following may help:-

Please Login or Register  to view this content.

The code will also clear the cell colour so that it is not over written with each subsequent running of the code.
The code also assumes that row1 has headings and data starts in row2.

I hope that this helps.

Cheerio,
vcoolio.

Originally Posted by vcoolio

Hello BeaglesBuddy,

If I've understood your request correctly then the following may help:-

Please Login or Register  to view this content.

The code will also clear the cell colour so that it is not over written with each subsequent running of the code.
The code also assumes that row1 has headings and data starts in row2.

I hope that this helps.

Cheerio,
vcoolio.

Perfect Thanks!