Evaluate in VBA not working
I'm using the below code to place the resulting value in cell A16. However, I get an error, bad syntax, when running the macro. I looked online to try to get the right syntax, but haven't had any luck. Any assistance with modifying the code to work would be much appreciated.
Please Login or Register to view this content.
Did you try Application.Evaluate instead of ActiveSheet.Evaluate?
If you are happy with my response please click the * in the lower left of my post.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Shg, thanks for the fix, the extra "" worked! One more issue though: I don't get any error when I use the following code:
However, I get a #Value! result when using the following. This doesn't happen when I input the formula directly into the cell (without using the evaluate VBA function).Please Login or Register to view this content.
I know the formula is good, but I get a bad result using evaluate in VBA. Any ideas where I'm going wrong on this?Please Login or Register to view this content.
I don't, other than that unqualified references (e.g., A31) are interpreted as being on the worksheet active when the line is executed, which makes the code less than robust.
Last edited by shg; 11-25-2015 at 12:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks