Hope you guys can help. I need a macro to search in a set range of cells, and return the full list of all cell coordinates of a particular colour to another sheet (so I can then use them to find the row and column titles)
Thanks!
Hope you guys can help. I need a macro to search in a set range of cells, and return the full list of all cell coordinates of a particular colour to another sheet (so I can then use them to find the row and column titles)
Thanks!
I don't know what the colour is, depending on the colour, you may need to use rgb values instead of named colours since not many are supported, but something like this should work?
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Fantastic, thanks very much
My pleasure
If the issue is resolved please mark the thread as solved?
All done. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks