Convert Formula's references to values in formula in Excel VBA

Is it possible using VBA to convert the formula =n2+m2 into its actual values on another sheet. For example cell m2 is 0, and n2 is 96,879 on sheet1. I'd like to have on sheet2 a formula be inserted in cell a1 for example, that is =0+96879. It is an audit trail of sorts. This would actually be performed on a large range, but that is the general idea. I've been looking for hours and come up with nothing.

Answers


Yes and no. It's possible, but it's a pretty gnarly task.

Refer to this link, for some discussion about various methods:

Does Excel have a built in method for parsing formulas? (ie: to obtain a list of included RANGE references)


In sheet 2 A1 enter

 =Sheet1!n2&"+"&Sheet1!m2

If you want the = Sign to Then just do

="="&Sheet1!n2&"+"&Sheet1!m2

Need Your Help

Java-EE6: Does InitialContext really needs to consume 228 MB of memory?

java-ee memory glassfish

I'm currently developing a 3-tiered application with Glassfish 3.1.2.2 / MySQL 5.5 and a stand-alone Swing client written in Java SE 6. I use JNDI to look-up references to my enterprise beans on the

javascript getElementsByClassName value error

javascript class get

I've got a little function in javascript popUp and i am wondering if getElementByClassName function returns an array of all elements with that class than why when i'm alerting it says object Html i...