Dear Mansoor,
short-cut key sequence for paste special value
Alt+E+S+V
or
Writing a subroutine in Personal.xls and giving it a shortcut key like:
VBA:
Sub PasteValues()
Selection.Formula=Selection.Value
End Sub
--
Thanks & regards,
Noorain Ansari
*http://excelmacroworld.blogspot.
Sheets("Sheet1").UsedRange.Value = Sheets("Sheet1").UsedRange.Value
Don Guillett
SalesAid Software
dguille...@gmail.com
From: danial mansoor
Sent: Tuesday, January 24, 2012 8:25 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ paste special dialogue box
is there an easy way to paste special values or using vba get paste special
dialogue box.?
hope i get best solution
> From: dguille...@gmail.com
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Paste Special Data with 2 decimals (Permanently)
> Date: Tue, 24 Jan 2012 07:35
