ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VSTO: Sheets collection a 1-based array(?!?!?) (https://www.excelbanter.com/excel-programming/345275-vsto-sheets-collection-1-based-array.html)

Bob Sullentrup

VSTO: Sheets collection a 1-based array(?!?!?)
 
Folks,

I have concluded, possibly erroneously that Sheets, as in:

(Excel.Worksheet)thisApplication.Workbooks[result_wbk].Sheets

is a 1-based array.

((Excel.Worksheet)thisApplication.Workbooks[result_wbk].Sheets[i]).Name

works when i=1; fails if i=0;

Have not been smoking anything. What false expectations do I have?

--
Bob Sullentrup


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com