How to select Formula cells with red interior?
Nope, you need to go find em.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
<donoteventry; <removes; wrote in message
...
2003
Is there a way to select all formula cells with i.e. a red interior color
in one selection?
I do know the following:
Set MyRange = Selection.SpecialCells(xlFormulas, 23)
But without processing all MyCells in MyRange individually, can I
select ALL formula cells with a red interior then change ALL to
yellow?
Thanks
EagleOne
|