excel application-defined or object-defined error

[sf123]

I assigned a macro to a menu in my toolbar. The macro calls my program and displays a predefined chart in my excel spreadsheet. The program ends without any runtime errors. After displaying the chart,however, I get the following error in excel:
application-defined or object-defined error
What does this mean?

 

[BrainB]

Have you tried stepping through the code in VB Editor ?
AFAIK this usually means that something in a line of code does not match with a Dim statement. Regards
BrianB
** Let us know if you get something that works !
================================

 

[melvt69]

I have the same problem. I run my app, then at the end it gives me this error. There's no error-number with, so i can't trap it. i've tried debugging through the code, but can't catch it. it also doesn't happen consistently - a bit of a trial and error problem.

Please help?? This is urgent...

Thanx.
mel.

 

[SkipVought]

Hi,
If your Chart is selected, then maybe the action your next line of code is trying to act on the chart instead of your sheet.

Insert a cell selection and see if that helps. Skip,
Skip@theofficeexperts.com

 

[melvt69]

Oh crap - i forgot to mention that i am not using a chart. i have this built-in menu, i select an option, a input form pops up, the user inputs parameters (selected from combo boxes), clicks RUN. The report gets generated completely and just as the program ends, this error pops up: "Application-defined or object-defined error"

 

[SkipVought]

Hey mel,
Post your own problem, NOT in sf123's thread. Same principle, though -- check what objects have been selected in your routine. Skip,
Skip@theofficeexperts.com