Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro required please | Excel Discussion (Misc queries) | |||
Macro Help Required | Excel Discussion (Misc queries) | |||
Effecient method of copying and pasting required | Excel Programming | |||
Macro required | Excel Worksheet Functions | |||
Pilgrim needs help: Effecting keystroks required by a macro nested within a macro. | Excel Programming |