At its simplest from a coding point of view you could try something like:
Sub blah() For Each sht In Sheets sht.Activate CellColorsToChart Next sht End Sub
At its simplest from a coding point of view you could try something like:
Sub blah() For Each sht In Sheets sht.Activate CellColorsToChart Next sht End Sub
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.