Copy+Paste "value" not formula macro ( Excel 2010 )

[ExcelJunkies]

Hi there,

I am using excel 2010, and i would like to know how to setup a macro to copy + paste the value instead of the formula.

excample


A1 Cell : =A2+A3

A1 = 3
A2 = 2
A3 = 1

I press a button, and then it copy's cell A1 to B1 with only the value not the formula.

Thanks for reading.

[G e r a r d]

Please Login or Register  to view this content.

Groeten
Gerard

[TMS]

One way:

Please Login or Register  to view this content.

Assign the macro to your button.


Regards, TMS

[ExcelJunkies]

Thanks allot for your help!!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Victor Lim]

Hi TMS,

May I know what I need to change in the macro if I want to paste the result into sheet 2?

Appreciate your reply..thks

Victor

[TMS]

Hi Victor, welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[Victor Lim]

thks...will do that...