Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

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. > >

Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

Thanks David. Will try to incorporate this into the macro. Cheers Ravi On 17 Dec 2017 7:20 am, "who" wrote: > Might try this too. Thanks, David > > Sub CopyPasteAll() > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues >