CODEWITHSUNDEEP
excelvba
Nandini Joshi
Nandini Joshi

Reputation: 219

How to copy everything including logo to a workbook from a worksheet

I am trying to copy a sheet from one Workbook to another using . I am using the following code:

ThisWorkbook.Sheets("Invoice").Cells.Copy

When I run it only the cells get copied and logo isn't getting copied. How to I change this to copy the logo also?

Upvotes: 1

Views: 100

Answers (1)

brettdj
brettdj

Reputation: 55672

Simply copy the entire sheet rather than the Cells

Something like this to copy from the Workbook containing the code to the first sheet of Book1

ThisWorkbook.Sheets("Invoice").Copy Workbooks("Book1").Sheets(1)

Or from the ActiveWorkbook

ActiveWorkbook.Sheets("Invoice").Copy Workbooks("Book1").Sheets(1)

Upvotes: 2

Related Questions