View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Sullentrup Bob Sullentrup is offline
external usenet poster
 
Posts: 25
Default 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