Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks, David
On Sunday, December 17, 2017 at 12:12:31 AM UTC-8, Ravi K wrote:
>
> Thanks David.
> Will try to incorporate this into the macro.
>
> Cheer
How about simply copy and paste values and do it to the the whole sheet?
Sub CopyPastVal()
Cells.Copy
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
Thanks, David
On Tue, Dec 19, 2017 at 3:31 PM, wrote:
> excel-macros@googlegrou
Please share profile on ja...@nestarit.com
Direct contact number: (201) 448 1184
This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH LLC* and we have
an immediate requirement with our client where we have excellent hold and
can close the positions pretty quick. If you find yourself comfor
On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: excel-macros@googlegroups.com
Date: Tuesday, December 19, 2017, 3:29 AM