Okay,
So, I've a question!
I was wondering if there's a way to write a Cell formula in VBA and essentially have it be flattened so that when referencing that cell it looks just like the result of the formula and not the formula itself.
So, essentially, if I wrote a really simple concatenation or did one with & the cell would only exist as the result of the formula.
So, a simple example might be
=A1+A2, where A1 is 1 and A2 is 2. The result is obviously 3, however, when accessing the cell it's the original formula as opposed to the result and I'm looking just for the result.
Thanks!
Bookmarks