Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by austin123456; 10-09-2013 at 02:39 PM.
Don't see how much simpler those lines of code could be but perhaps something like this.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Please Login or Register to view this content.
Thanks Norie,
I hope that skip value to value
Sorry I don't follow.
What exactly are you trying to do?
austin123456,
Aren't you basically just trying to do...
?Please Login or Register to view this content.
unless the formula would produce a different result in the different cell. In which case Norie's solution is preferred.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi tigeravatar,
I want to short the sentence from Range("A2"). XXXXXXX = Range("A1").FormulaR1C1
directly from FormulaR1C1 change XXXXXXX result value
What is the formula in A1?
Will it give a different value if it's in A2?
Sorry ALL, I know that need to doing two step from formula to result to value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks