Gotcha: Worksheets property is read-only, Sheets is not – Excel Workbook
My contribution to:
Seems Worksheets property is read-only
Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.
https://msdn.microsoft.com/en-us/library/office/ff835542(v=office.15).aspx
whereas Sheets is the real thing where you can also add Sheets dynamically
A collection of all the sheets in the specified or active workbook.
https://msdn.microsoft.com/en-us/library/office/ff193217(v=office.15).aspx
Categories: Posts
API, Excel, Gotcha, Scripting, Sheets, Speadsheet, VBScript, Worksheets
Comments (0)
Trackbacks (0)
Leave a comment
Trackback