Macro for Pasting Values

[Markymark123]

Hi,

Can someone tell me what the Macro would be for pasting values?

I use this function all time and would like to have a macro for it.

Also I've tried to use the recorder fcn but it's not working either.

Thx

 

[Smitty]

Welcome to the Board!

You can use pasteValues:

<font face=Tahoma><SPAN style="color:#00007F">Sub</SPAN> Macro1()
    <SPAN style="color:#00007F">With</SPAN> Selection
        .Copy
        .PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=<SPAN style="color:#00007F">False</SPAN>
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN>
    Application.CutCopyMode = False
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

HTH,

Smitty

 

[Marc]

Another way to accomplish this without a macro is to customize your toolbar.

1. Right Click the toolbar.
2. Choose Customize.
3. Choose the 'Commands' tab.
4. In the Categories box select 'Edit'.
5. In the Commands box scroll down until you see 'Paste Values'.
6. Drag it up to your toolbar.