Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error 32809
Since Microsoft doesn't support the OEM software they sell, and the MSDN
forums don't support us Office Developers, I sure hope someone has the answer to this complicated situation. I'm running Excel 2003 on Windows XP. A very complicated spreadsheet I'm working in, was working just fine saturday. Today when I opened it up, and tested one of the buttons, it failed on a 'Run-time Error 32809: Application-defined or object-defined error.' It's breaking on trying to activate a sheet: Sheets("AKtie").Activate I go to the formerly working sheet, and none of the buttons are working on it. In the watch window, you can look at the Sheet, but if I type in Sheets("AKtie").Name it gives the error, though I can see the name when I only type in Sheets("AKtie") in the properties. I've looked through Object Explorer and haven't seen any naming conflicts there. Any ideas on how to not just fix this bug, but what's really causing it so I can prevent it in the future. Note: I'm trying to avoid the old 'copy to a new sheet' fix, since Excel is very buggy when copying with a lot of named ranges (especially sheet-level named ranges). -- Lance Roberts Control Systems Engineer Golden Valley Electric Assoc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error 57121 & 32809, Excel 2003 SP2 | Excel Programming | |||
runtime error '1004' application or object defined error | Excel Programming | |||
unexpected error (32809) | Excel Programming | |||
Errors 32809 and 57121 :-( | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |