VBA Pastespecial

I need to paste the entire contents of one worksheet to another but only its formatting and values (no formulas).

I am using this so far:

wksDb.Cells.Copy wksOut.Cells

Open in new window

LVL 2
mcnuttlawAsked:
Who is Participating?
 
Zack BarresseConnect With a Mentor CEOCommented:
@Shanan212: You don't need to Select anything here.  Just access the range object...
wksDb.Cells.Copy
wksOut.range("A1").PasteSpecial xlPasteValuesAndNumberFormats

Open in new window


HTH
Regards,
Zack Barresse
0
 
Shanan212Connect With a Mentor Commented:
assuming you paste on A1


wksDb.Cells.Copy
wksOut.range("A1").select
Selection.PasteSpecial xlPasteValuesAndNumberFormats

Open in new window

0
 
mcnuttlawAuthor Commented:
Thank you both.
0
All Courses

From novice to tech pro — start learning today.