Select Multiple Worksheets

**plans** · 06-15-2014, 04:57 PM

I am running this routine:
For Each wksSheet In Worksheets
If condition = something then
wksSheet.Select
End If
Next
I would like to keep all the selected worksheets selected, similar to what I would be getting when manually selecting with holding the Ctrl Key.
How is this getting done?
Thanks

**Norie** · 06-15-2014, 05:07 PM

Put False after wksSheet.Select.

PS Can you add code tags when posting code?

Select Multiple Worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Select Multiple Worksheets

Re: Select Multiple Worksheets

Thread Information

Users Browsing this Thread

Similar Threads

Multiselect Listbox to select multiple worksheets

[SOLVED] Select Multiple Worksheets based on Cell Array

Select cells from multiple worksheets

Moving select worksheets from multiple file to one workbook

[SOLVED] How do I select multiple worksheets for print preview?

Bookmarks

Bookmarks

Posting Permissions