Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting Multiple Sheets in VBA
Hi folks,
Is there a way of selecting a variable number of worksheets in VB so that I can apply a simultaneous fix. I can't do the sheets 1 at a time as the fix includes inserting some columns and the references will go screwy. It is possible to do manually so should be possible in VB. The equivalent of holding the control key and clicking on the tabs you want. I would be looking at 'selecting' all the tabs between "START" and "END" (these will have user defined names so cannot be specified in the macro) and then 2 additional pre-defined tabs. Any ideas anyone? Giz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Select Multiple sheets | Excel Discussion (Misc queries) | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |