VALUE PASTING MACRO REQUIRED

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

Guest

SIR,
I need to know that is there any key or you can create me any macro
which paste the value.

Thanks
Regards
ZEESHAN ANIS
 
Sub PasteValues()

On Error Resume Next
Selection.PasteSpecial Paste:=xlPasteValues
If Err <> 0 Then
MsgBox "Please select something to paste."
Exit Sub
End If
On Error GoTo 0
End Sub
 

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

FORMAT PAINTER KEY REQUIRED 1
Run Macro If Cell have "x" value 0
SEGREGATE THE SIR NAME 4
ADDIN TOOLS 1
Macro Related to Paste Values 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Update this macro to make it generate a counter as text 7
How to use OFFSET in VBA 1

Back
Top