Check if SpecialCells are selected

[bsamuels]

I have some code which selects only the formulas in my selection:

Please Login or Register  to view this content.

However, if there are no formulas in the selection, I get a 1004 error. How can I go about checking whether or not there are any formulas contained in my selection?

[stnkynts]

One way:

Please Login or Register  to view this content.

[Marc L]

Please Login or Register  to view this content.