Finding cells that contain formulas

[T]

Having a mental blank and don't have Help installed so...can anyone remind me of the function to use when searching for cells containing formulas...? Is it SpecialCells? What's the syntax?

Cheers

 

[NateO]

Howdy T, me thinks it should look something like:<pre>
Set MyVariable = _
ActiveSheet.[a1].SpecialCells(xlCellTypeFormulas)</pre>


_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-05 23:05