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