Hey there, I've been trying to get a macro together which would colour all the tabs in my workbook based on whether or not a certain value exists in a certain cell. In this case the cell is C7 and the word there is "elective class:".
At the moment this is what I have come up with:
However it doesn't work, it colours everything as though "elective class:" exists on none of the sheets. How can I correct this?
Also I am actually going to go further with this code and will want all the sheets of one colour next to each other and all the sheets of the other colour next to each other. Excluding however the first 6 sheets which should be ignored by the macro. If anyone can help with this at the same time it would be appreciated as I have no clue how to do this part.
Many thanks,
Tom
P.S. Personally if I remember correctly I think it might be something to do with using the mySht.Range("C7").Value part of the macro. I seem to remember having a similar problem with text before. I tried changing the word Value to the word Text but to no avail.
Bookmarks