Hi
AFAIK you can't do this. You have to loop through all cells

--
Regards
Frank Kabel
Frankfurt, Germany
"Darin Kramer" schrieb im Newsbeitrag
...
Howdie,

If a cell has been coloured, and I want to replace all the colours to a
new colour, I think I can do a find and replace for that colours
number... but where do u see its number? (not under properties...?)

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

you need a custom function

function Mycolor(cell as range)
Mycolor=c.interior.colorindex
end function



"Frank Kabel" wrote in message
...
Hi
AFAIK you can't do this. You have to loop through all cells

--
Regards
Frank Kabel
Frankfurt, Germany
"Darin Kramer" schrieb im Newsbeitrag
...
Howdie,

If a cell has been coloured, and I want to replace all the colours to a
new colour, I think I can do a find and replace for that colours
number... but where do u see its number? (not under properties...?)

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!