Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have an Excel 2003 VBA app that while I am programmatically deleting all but the last 3 sheets that remain-after they are deleted-I get the above error. It won't allow me to set a break point in the code but the error apparently occurs at the end of performing the For statement, and doesn't perform any code afterwards. For ndx = Workbooks("Quotes.xls").Worksheets.Count To 4 Step -1 Workbooks("Quotes.xls").Worksheets(ndx).Delete Next ndx The code to my knowledge is not affecting the merged cells unless inadvertently. Any ideas what the problem could be. I am past a deadline for getting a demo to a client so any help would be appreciate. Thanks, God bless, Van |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error '1004' application or object defined error | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Cannot change part of a merged cell | Excel Programming | |||
ClearContent & 'Cannot change part of a merged cell' error | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |