CODEWITHSUNDEEP
vbaexcel
excelguy
excelguy

Reputation: 1624

VBA, copy columns with formulas to new worksheet as values

I would like to take a sheet that has vlookups and paste them as values into my new sheet.

  ws3.Columns(4).Copy Destination:=Sheets("Sample File").Columns(1)

I get REF error after doing this.

Upvotes: 1

Views: 232

Answers (1)

Subodh Tiwari sktneer
Subodh Tiwari sktneer

Reputation: 9976

You should try it like this...

ws3.Columns(4).Copy
Sheets("Sample File").Columns(1).PasteSpecial xlPasteValues

Upvotes: 2

Related Questions