How to count the number of worksheets selected?

Bassman62 · Apr 3, 2009

Using VBA, how can I count the number of worksheets selected?
I'm trying to test if there is more than one worksheet currently selected.
Thank you.

Peter T · Apr 3, 2009

ActiveWorkbook.Windows(1).SelectedSheets.Count

Regards,
Peter T

joel · Apr 3, 2009

Num = ActiveWindow.SelectedSheets.Count

Bassman62 · Apr 3, 2009

Peter,
Thank you very much. That's nice.
I tryed several combinations but missed the .Windows(1).
I'll study up on this term.
Thanks again.

Bassman62 · Apr 3, 2009

Thanks Joel,
This works well also.

joel said:
Num = ActiveWindow.SelectedSheets.Count