Hi,

I'm looking to create a range that contains all the constant AND
formula cells in a selection. I've tried
'selection.SpecialCells(xlConstants) and
selection.SpecialCells(xlFormulas)' , but that doesn't work because
there may be only one type of cell in the selection - constants or
formulas - and then instead of combining a range with a null set, Excel
throws an error because there are no cells in one of the sets.
It seems there should be an easy way to do this but I haven't found one
online or in any of my books and I'm growing frustrated. Please help if
you have any ideas!

Allison


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