If Special Cells count is zero

[jomili]

Should be simple, but for me not so much. Here's what I'm trying to do: IF there are any formula cells in my selection shut it down, otherwise do my stuff. My problem is when there are no formula cells, excel throws up an error saying no cells are found. Any help is appreciated.

Please Login or Register  to view this content.

[HaHoBe]

Hi, jomili,

one way around raising the run-time error is to do it like this:

Please Login or Register  to view this content.

Ciao,
Holger

[LJMetzger]

Hi jomili,

You need to 'trap' the Runtime error, so you can continue processing with syntax like the following:

Please Login or Register  to view this content.

Lewis

[jomili]

Thanks Holger, that seems to work well. I appreciate the help.

[jomili]

Sorry Lewis, guess I was posting the same time you were. Thanks for the help.