I have looked at other boards but I cannot seem to figure out how to put a function into VB code and have it work correctly
I am trying to put this formula into VB:
=INDEX('Data'!$G:$G,MATCH($C$6,'Data'!$C:$C,0)+4)
Following some other pages I have tried to use this:
Thanks in advanced for your help
Please Login or Register to view this content.
Last edited by Pontiac; 10-05-2015 at 04:41 PM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
fixed the post error
Here, try this:
And please don't delete your question today.Please Login or Register to view this content.
It's not polite.
I just get the same error that says invalid outside procedure
Pontiac
When I need to evluate formulas in VBA I use this type of writing:
and usually it works wellPlease Login or Register to view this content.
The Name (string) argument of the Evaluate function doesn't start with an equal sign. Try this:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
How about
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks