| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting sheets
How can make my code add a sheet to a selection?
Something like: Dim WSName As Worksheet For Each WSName In Worksheets If Left(WSName.Name, 3) = "Pre" Then 'the code for adding the sheet to the selection End If Next Thanks The Doctor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| To data apearing in other sheets I can use =SUM(. How I can have . | Excel Worksheet Functions | |||
| PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
Threaded Mode
