View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juraj[_2_] Juraj[_2_] is offline
external usenet poster
 
Posts: 1
Default Worksheet Selected Names

Hi,
I would like to get the list of names of worksheets which
are selected (marked with the mouse).

e.g.
I have 3 work sheets:
Table1
Table2
Table3
I select two of them Table1 and Table2. I am looking for
the code which gives me only this two names!!

To get all available worksheet names the following code
can be used:

For Each ws In Worksheets
MsgBox ws.Name
Next ws

Thank you for help.
Juraj.