It is quite easy to manually select multiple sheets. It is also quite easy to do this in VBA using an array statement, for example
[vba]Worksheets(Array("A","B")).Select[/vba] But assuming that multiple sheets have been selected manually, how do you determine that in VBA?
"It's not just the due date that's important, it's also the do date" [MWE]
When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.
[VBA]Excel.Windows(1).SelectedSheets.Count[/VBA]
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Posting Permissions
Reply With Quote
