How do I copy the value from a cell without copying the formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to, as my question states copy the value of a cell without copying
the formula, that way my simple macro can repeat. Is this possible?
 
Click <copy> on the cell with the formula in. Move to where you want
the value to appear, then use Edit | Paste Special | Values (check) OK
then press <Esc> or <Enter>. This fixes the value in the second cell.

Hope this helps.

Pete
 
Don't know if I get your problem but maybe you should just use:

Copy and then Paste Special.

Right click and choose PASTE SPECIAL. Then click Values. If it's ok it
just copy's the values and nothing more!

Goodluck!
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
Return of value when copying a formula 4
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Copy value from changing cells without VBA 1
Excel In Excel how can I block the contenent of a cell? 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
I want to save a copy of a wksht. but without any of the formulas 5
formula copies value from original cell only 1

Back
Top