worksheetS.copy vs worksheet.copy

[lezawang]

Hi
I understand Worksheet.copy and what is used for. But to my surprise, I see Worksheets the collection has a functions called copy ,move and delete as well. What are these for? Thank you.

 

[Michael M]

I know you can Activesheet.copy, but not singular worksheet.copy.....it's always worksheets.copy OR Sheets.copy.
If you read about worksheet.copy on the Microsoft page, you will notice all of the provided examples are worksheets.copy OR Sheets.copy.

 

[lezawang]

Thank you. I meant Worksheets(1).copy which is equivalent to worksheet.copy, I meant worksheets(1) is a worksheet object which has a method called "copy"; hence I said worksheet.copy. I understand Worksheets(1).copy but I do not see what is the use of WorkSheets.copy (worksheets is the collection object)

 

[lezawang]

I meant
Worksheet (the object) has methods like move, copy, and delete. I understand these methods
Worksheets (the collection object) has methods like move, copy and delete. For what these functions are used

 

[Michael M]

Worksheets the collection is used when moving / copying more than one sheet

See here...

https://docs.microsoft.com/en-us/office/vba/api/excel.worksheets

 

[lezawang]

Yes that is what I was looking for. I googled Worksheets.copy but they all taking about the worksheet object dot copy. That link is amazing. Thank you so much.