Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group worksheets
Hi
I'm trying to group worksheets, and not having much luck. I have tried this with and without arrays. I am using the sheet code names, not the tab names, and this is when I started having problems. The tab names worked until different tab names occured. Where am I going wrong? With MyBook Sheets(array("Sheet13", "Sheet14", "Sheet15", "Sheet16", "Sheet17", "Sheet18", "Sheet19", "Sheet20", "Sheet21", "Sheet22", "Sheet23", "Sheet24")).Select Sheets("sheet13").Activate Call UpdateVlookup Sheets("Sheet1").Activate Sheets("Sheet16").Activate ActiveWorkbook.Save ActiveWorkbook.Close End With Thanks for your help Fred |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Group Worksheets | Excel Programming | |||
Cannot Group Seven Worksheets, only Six | Excel Discussion (Misc queries) |