Hi, Zorro9758,
maybe
But I would go the other round and copy only those sheets you want to upload to a new workbook.![]()
Sheets(Array("Sheet1", "Sheet5", "Sheet7")).Visible = False
CIao,
Holger
Hi, Zorro9758,
maybe
But I would go the other round and copy only those sheets you want to upload to a new workbook.![]()
Sheets(Array("Sheet1", "Sheet5", "Sheet7")).Visible = False
CIao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Do you have a macro where I can copy those specific sheets into new worksheet?
Hi, Zorro9758,
just like
This will copy Sheet4 and Sheet5 to a new workbook.![]()
Sheets(Array("Sheet4", "Sheet5")).Copy
Ciao,
Holger
Great than you for you help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks