Hi all,
I always have above error while running below code in the excel 2007,
please help me out!
The function I used in the excel is:Please Login or Register to view this content.
Source = X*X +X*300
Regards,
Edward
Hi all,
I always have above error while running below code in the excel 2007,
please help me out!
The function I used in the excel is:Please Login or Register to view this content.
Source = X*X +X*300
Regards,
Edward
Last edited by edwardhdwang; 05-13-2010 at 07:07 PM. Reason: add code tag
Try
The variables are ranges and not values.Please Login or Register to view this content.
Martin
Welcome to the forum, edwardhdwang.
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
Thanks.
Entia non sunt multiplicanda sine necessitate
it works now. But after I changed the Goal from -800 to -200, it shows up "Reference is not valid". BTW, how this change solves the issue, I have no clue. Please give me some explanation.
Thanks lot!
-200 seems to work for me. Maybe there is something else on your sheet that is causing the problem?
My solution creates X and Source as ranges (this is done with the Set statement). As ranges, the goalseek method can work directly with them.
Thanks! It solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks