Still can not find this error message documented

rpwagner · Mar 14th, 2002, 04:11 PM

Expression not defined in context. I have done searches all over the place and can not find this error message that appears in the vb watches screen. can anyone help me on this/

Joe Was · Mar 14th, 2002, 04:23 PM

Posting the error from Excel will do little good. Even if it was a common error, with out your code or formula we will only be able to give a general answer. Post your code!

I will tell you this: The error message you have posted is given when you are using a property or method out side its designed context. Like using a graph plot property to modifiy a font. You may think that you can use what ever you are using, but Excel is telling you that it cannot use part of your code from that "line" or within a "With or If" block with the other parts of the code you are using.

Tell us what you are trying to do and show us the code! Hope this helps both of us. JSW

Jack in the UK · Mar 14th, 2002, 05:04 PM

Hi

Simply Excel well VBA dont like something

Run debug to find the effected line, can i secod some code would help, we will run it and try to fix...

Code is not secret the data in the sheet might be of casue so no worrys there...

Mar 14th, 2002, 05:04 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Simply Excel well VBA dont like something Run debug to find the effected line, can i secod some code would help, we will run it and try to fix... Code is not secret the data in the sheet might be of casue so no worrys there... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 04:11 PM	#1
rpwagner New Member Join Date: Feb 2002 Location: Robert P. Wagner Posts: 22	Expression not defined in context. I have done searches all over the place and can not find this error message that appears in the vb watches screen. can anyone help me on this/

Mar 14th, 2002, 04:23 PM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	Posting the error from Excel will do little good. Even if it was a common error, with out your code or formula we will only be able to give a general answer. Post your code! I will tell you this: The error message you have posted is given when you are using a property or method out side its designed context. Like using a graph plot property to modifiy a font. You may think that you can use what ever you are using, but Excel is telling you that it cannot use part of your code from that "line" or within a "With or If" block with the other parts of the code you are using. Tell us what you are trying to do and show us the code! Hope this helps both of us. JSW