Change cell color depending on cell color, error in code
I've trying to create a macro that changes all the grey cells to yellow cells. I've created a code that I think should work but it doesn't and I can't find what I've done wrong.
Any help would be greatly appreciated. The document I want to change the cells colors in has some merged cells that why I have the extra functions in the bottom of the code.
Best Regards
Please Login or Register to view this content.
Lars
You're setting a variable to the color index, but not setting the cell to be that color index
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thank you for the fast reply.
I tried making the recommended change, but now it just gets rid of the fill and leaves the cell blank. It doesn't change the color to nr 36. Any tips?
Edit: It gets of the fill in all colored cells not only cells with color 15
You will need to add c.Interior.ColorIndex = iColorIndex before the next c in your code, you need the rest of the code.
Thanks for the help it worked perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks