Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which sheets are selected? 1

Status
Not open for further replies.
simoncpage

simoncpage

Programmer
Apr 4, 2002
256
GB
Hi all, can anyone tell me how to find out which sheets are selected i.e if two tabs are selected??

thanks

Simon
 
Sort by date Sort by votes
for i=1 to activewindow.selectedsheets.count
msgbox activewindow.selectedsheets.item(i)
next i

Rob
[flowerface]
 
Upvote 0 Downvote
for i=1 to activewindow.selectedsheets.count
msgbox activewindow.selectedsheets.item(i).name
next i

Rob
[flowerface]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Fishing for Ideas on sorting sheets in workbook
Replies
5
Views
321
SkipVought
S
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
600
Andrzejek
Andrzejek
kapok1
  • Locked
  • Question
add all the files under the same folder including the subfolder, all sheets in worbook included
Replies
2
Views
205
kapok1
kapok1
kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
377
kapok1
kapok1
EliseFreedman
  • Locked
  • Question
Controlling which columns are visible when drilling down in a pivot table
Replies
2
Views
249
combo
combo

Part and Inventory Search

Sponsor

Back
Top