Hello all,
I'd like to write a macro that selects all cells with a certain background. The color I'm looking for is (255,217,102). I want to select all cells in the sheet with this background color, and then change the value of these cells. I'm fairly certain this can be done, but I've never been great with VBA. This is what I'm trying so far:
0 is not the actual value I want but I've been using it to test.
Please Login or Register to view this content.
Can someone please help me?
Last edited by JBeaucaire; 02-12-2013 at 11:40 AM. Reason: Added code tags, as per forum rules. Don't forget!
you can filter on cell colour
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I can't get the filter to work because of merged cells...any way to do this with a macro?
rule 1 don't merge cells
rule 2 see rule 1
Someday I'll be my own boss and not merge any cells.
In the meantime, can anyone help me.
untested
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks