Is this possible

T

Todd Virlee

Value1 Value2 Value3

Where the above are in cells A1, A2, and A3.

If a different cell has a formula =A1+A2, can we have a macro that would put
the translation in a cell below it, so it would look like =Value1+Value2?
 
P

Paul

Assuming the initial formula is in say C4. Then this would do it.

Sub ValuesInFormulaInstead()

Range("C4").Offset(1, 0).Formula = "=" & (Range("A1").Value) & "+" &
(Range("B1").Value)

End Sub

But why do this?

Paul
 
T

Todd Virlee

There is another program they use that uses the "friendly" names of their
columns so they want to be able to have a value to paste in the other
program. This macro would need to be dynamic to the cell they are on in the
sheet when they run the macro.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this possible? 3
Issue with conditional formatting - Formula changing 1
Parsing a text field to retrieve numeric values 7
Split cell value and add to array 4
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Copying Sheet1 to Sheet2 in a certain pattern 6
Copy rows to different sheets 1
conditional formatting for ratios between rows? 3

Top