COPY VALUE ONLY

[benzgc]

I have made a macro that does a "copy paste" action. Because the "copy" is on a formula cell, the macro has to do a "paste special" function to just put the numeric value into the new cell. Now i need to copy just the numeric value into the clip board, control c is putting the cell in the clip board not the contents i just want the contents.

any ideas?

BENZ

 

[DonKlein]

Using the classic keys, / Range Value copies the value of a formula and allows you to copy it to the same or another cell.

 

[slotcardan]

Continue your macro with {EDIT-COPY} then move your cellpointer where ever you want and do {EDIT-PASTE}.

 

[crazybird]

I would use {RANGE-VALUE destination;[origin]} which is equivalent to the classic /RV but behaves a little better using R9.x .