LinkBack URL
About LinkBacks
Yep, the Sub Test worked for me. I'll have to try the other example you gave. but if the Evaluate function worked then there should be no reason why the first example would have an issue right?
Yep, the Sub Test worked for me. I'll have to try the other example you gave. but if the Evaluate function worked then there should be no reason why the first example would have an issue right?
That is correct. The Evaluate() function is simply running a worksheet formula in memory instead of in a cell (much faster), so if it works, it works.Originally Posted by excel_guy49
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks