ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VALUE PASTING MACRO REQUIRED (https://www.excelbanter.com/excel-programming/394579-value-pasting-macro-required.html)

ZEESHAN ANIS[_2_]

VALUE PASTING MACRO REQUIRED
 
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

Anony

VALUE PASTING MACRO REQUIRED
 
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

--------
Cheers,
Anony


"ZEESHAN ANIS" wrote:

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



All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com