Thanks for the reply.

Unfortunately, there aren't always formula cells in the range.
In that case, Excel doesn't get past the line

Set rng2 = Range("A1:C25").SpecialCells(xlFormulas)

because it throws an error saying that no cells were found. I don'
know why it can't have a null set

--
Stacy3521
-----------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...fo&userid=1595
View this thread: http://www.excelforum.com/showthread.php?threadid=27432

Always use a on error with specialcells
See Norman's example


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Stacy35216" wrote in message ...

Thanks for the reply.

Unfortunately, there aren't always formula cells in the range.
In that case, Excel doesn't get past the line

Set rng2 = Range("A1:C25").SpecialCells(xlFormulas)

because it throws an error saying that no cells were found. I don't
know why it can't have a null set.


--
Stacy35216
------------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...o&userid=15952
View this thread: http://www.excelforum.com/showthread...hreadid=274326