removing format when copying and pasting in VBA

[monsierexcel]

hi all i have a really simple VBA copy/paste b ut cant remove the formatting from it - any ideas please?

Sheets("sheet2").Range("C2:C500").Copy Destination:=Sheets("Totals").Range("A2")

 

[dmt32]

Hi,
try

Sheets("sheet2").Range("C2:C500").Copy
Sheets("Totals").Range("A2").PasteSpecial xlPasteValues
Application.CutCopyMode = False

Dave

 

[monsierexcel]

thank you ever so much Dave!!

 

[dmt32]

thank you ever so much Dave!!

most welcome
Thanks for the feedback

Dave