| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object?
doing the commented out stuff below doesn't work. i will be adding
worksheets and so i want to have a collection to start with and just use those thru my code. Dim startSheets As Worksheets Dim sheet As Worksheet 'Set startSheets = ActiveWorkbook.Worksheets 'For Each sheet In ActiveWorkbook.Worksheets ' startSheets.Add (sheet) 'Next thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide Worksheets | Excel Discussion (Misc queries) | |||
| Keep Format After Merging Worksheets Using CopyFromWorksheet Macro | Excel Discussion (Misc queries) | |||
| Print order of worksheets | Excel Discussion (Misc queries) | |||
| Duplicate Worksheets | Excel Discussion (Misc queries) | |||
| Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Threaded Mode
