Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro which has worked hundreds of times before.
Now, the macro quits when it gets to an Activesheet.Name = "Export" command. By quitting, I mean it's just as if it encountered an Exit Sub command. What would cause such strange behavior? I have other macros with Activesheet.Name in them, and they still work. I first encountered this problem at work where we have Office 2003 and Windows 2003. I find I have the same problem at home, where I'm running Office XP and Windows XP. When I step through the macro using F8, it highlights Activesheet.Name command properly. As soon as I hit F8, the macro quits -- the yellow highlight disappears and a data entry cursor appears. If I hit F8 again, the macro starts over at the Sub command. Any suggestions from anyone? -- Regards, Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel quits unexpectedly | Excel Worksheet Functions | |||
VBA (excel) quits on workbooks.open | Excel Programming | |||
Excel quits when saving Macro spreadsheets | Excel Discussion (Misc queries) | |||
excel will not bold a cell, then program quits | Excel Worksheet Functions | |||
excel will not bold a cell, then program quits | Excel Worksheet Functions |