I have this formula where cell D10=B10+C10.
I want to create a macro that once I run it, cell B10 takes the value
that is in cell D10 (while the above formula remains intact).
How can I do it?

Thanks.

I too need the same thing. Any response is greatly appreciated by me
also!

Thank you.

amirstal wrote:
I have this formula where cell D10=B10+C10.
I want to create a macro that once I run it, cell B10 takes the value
that is in cell D10 (while the above formula remains intact).
How can I do it?

Thanks.

I did a little search and found this. Let me know if it helps

From: Jan Paulsen - view profile
Date: Sat, Dec 14 2002 5:00 pm
Email: "Jan Paulsen"
Groups: microsoft.public.excel.programming
Not yet ratedRating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author



"Donald Sherman" wrote in message


news:usnLdK8oCHA.2412@TK2MSFTNGP12...


I'm trying to copy a range of cells to another part of an ActiveSheet.
I tried this but it's copying the formula and all I want to copy is the
results. Could someone give me suggestions as to want I need to add or
change.

ActiveSheet.Range("C9:C156").Copy _
Destination:=ActiveSheet.Range("C274")


Donald



Hi Donald,

I just tried the following, which should be what you need:


Sub test()
Range("B4:B7").Copy
Range("D4").PasteSpecial xlPasteValues


End Sub


BR,


Jan





cheeser83 wrote:
I too need the same thing. Any response is greatly appreciated by me
also!

Thank you.

amirstal wrote:
I have this formula where cell D10=B10+C10.
I want to create a macro that once I run it, cell B10 takes the value
that is in cell D10 (while the above formula remains intact).
How can I do it?

Thanks.

Sub makevalues()'Hilite the cells in D to change
For Each c In Selection
c.Offset(, -2).Value = c
Next c

End Sub

--
Don Guillett
SalesAid Software

"amirstal" wrote in message
ups.com...
I have this formula where cell D10=B10+C10.
I want to create a macro that once I run it, cell B10 takes the value
that is in cell D10 (while the above formula remains intact).
How can I do it?

Thanks.

Sub Macro1()

Range("B10").Value = Range("D10").Value

End Sub

"amirstal" wrote in message
ups.com...
I have this formula where cell D10=B10+C10.
I want to create a macro that once I run it, cell B10 takes the value
that is in cell D10 (while the above formula remains intact).
How can I do it?

Thanks.