View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Felix Felix is offline
external usenet poster
 
Posts: 78
Default How to return a list of all selected Sheets in a Workbook

I seem to be unable to return a list of all sheets in a Workbook that are
currently selected by the user. Basically I want to return the Array in

Worksheets(array("x",'y","z")).select

and I 'm having trouble finding a way to return the collection of selected
Worksheet once the are selected by the user.
Any help would be appreciated,

Felix