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
|