Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to combine two SpecialCells CellTypes?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specialcells | Charts and Charting in Excel | |||
How to combine two SpecialCells CellTypes? | Excel Programming | |||
SpecialCells(xlCellTypeFormulas) | Excel Programming | |||
AutoFilter /specialcells | Excel Programming | |||
specialcells(xlcelltypeblanks) | Excel Programming |