Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
I've been having this trouble for a long time: Is there any way I can check if a reference to a range object no longer exists? Eg, After creating a reference to a range: Range refRange = Application.ActiveCell; I delete the cell (eg, via removing an entire row/column), yet the refRange object still points to the deleted range object. When I try to use it, I get an exception. This problem persists with any type of Excel Interop objects (Name, Names, Range, etc). Was wondering if anyone know if I can check if an Excel Interop object is usable? Eg, checking if it's null or not. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Interop Excel | Excel Programming | |||
Excel VBA Class Objects - Parent & Successor Objects | Excel Programming | |||
Using Excel, how do I replace cells containing blanks with nulls? | Excel Discussion (Misc queries) | |||
How do I sort nulls within date field in Excel | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |