# 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:

In sheet 2 A1 enter

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

If you want the = Sign to Then just do

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