Re: $$Excel-Macros$$ paste special dialogue box

2012-01-24 Thread NOORAIN ANSARI
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.

Re: $$Excel-Macros$$ paste special dialogue box

2012-01-24 Thread dguillett1
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 t