The Worksheets Object (SAWorksheets)
Worksheets Methods and Properties
| Worksheets Methods and Properties |
| Add |
Adds a worksheet to your Excel application. To add second and third
worksheets to an existing Excel application, use,
xlw.Worksheets.Add
dim Worksheet2 as IWorkSheet
set Worksheet2 = xlw.Worksheets(2)
xlw.Worksheets.Add
dim Worksheet3 as IWorkSheet
set Worksheet3 = xlw.Worksheets(3)
Top |
| Count |
Counts the number of worksheets in your Excel application (workbook). To
retrieve the number of worksheets in your application, and assign the number to a
variable, use,
count = xlw.worksheets.count
Top |
| Item |
Represents a single worksheet in a Worksheet collection. Item is the default property
of Worksheets, so Worksheets(1) is equivalent to Worksheets.Item(1) . You can reference a Worksheets
item either by number or by name. Top |
Copyright © 2003, SoftArtisans, Inc.