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...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.