RE: $$Excel-Macros$$ A little OT

2011-02-16 Thread Dave Bonallack
knowledge. Regards - Dave. Date: Tue, 15 Feb 2011 05:00:59 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ A little OT To: excel-macros@googlegroups.com The biggest confusion here is the difference between the Worksheet OBJECT: Sheet1 the Worksheet NAME: Sheet1 and Sh

Re: $$Excel-Macros$$ A little OT

2011-02-15 Thread Paul Schreiner
The biggest confusion here is the difference between the Worksheet OBJECT: Sheet1 the Worksheet NAME:   Sheet1 and Sheets ARRAY: Sheets(1) An Excel workbook must contain at least one sheet. Excel will INTERNALLY "Identify" this sheet object as "Sheet1" and will initially NAME the sheet "Sheet