Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SpecialCells method of Range class failed
Hi,
I use Range.SpecialCells method (C#, Excel 2003) to filter visible cells. It works fine, but if cursor is in Formula Bar it rises an exception "System.Runtime.InteropServices.COMException (0x800A03EC): SpecialCells method of Range class failed". Can I force Range.SpecialCells to work in this situation? Or can I, at least, determine that cursor is in Formula Bar? In some cases (including described above) Excel's Visual Basic Editor becomes disabled. It seems, it was made intentionally to prevent Excel automation. Can anybody explain this situation? And how can I treat it in C#. Thank you in advance! Sergei. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select method of Range class failed | Excel Programming | |||
Delete method of Range class failed | Excel Programming | |||
AutoFilter method of Range class failed | Excel Programming | |||
Autofilter method of range class failed | Excel Programming | |||
Autofill method of Range class failed | Excel Programming |