View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] donoteventryremovespam@ameritech.net is offline
external usenet poster
 
Posts: 10
Default How to select Formula cells with red interior?

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