Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new sheets to the right instead of the default left
How could the line below so that new sheets are added to the right (instead
of the default left): Set WSNew = Sheets.Add Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new sheets to the right instead of the default left
Oops, it should read as:
How could the line below be amended so that new sheets are added to the right (instead of the default left): Set WSNew = Sheets.Add |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new sheets to the right instead of the default left
don't use both of these, just 2 examples Sub test() Dim wsnew As Worksheet Set wsnew = Worksheets.Add(after:=Worksheets(Worksheets.Count) ) Set wsnew = Worksheets.Add(after:=Worksheets("Sheet2")) End Sub -- Gary "Max" wrote in message ... How could the line below so that new sheets are added to the right (instead of the default left): Set WSNew = Sheets.Add Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new sheets to the right instead of the default left
Gary, thanks for the examples. Very helpful.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change from left-to-right as default setting | Setting up and Configuration of Excel | |||
Make left-to-right default direction | Excel Discussion (Misc queries) | |||
Make left-to-right the default | Charts and Charting in Excel | |||
Default left-to-right columns for imported files | Excel Discussion (Misc queries) | |||
Excel - change default 'next worksheet' shortcut key to left hnd s | Setting up and Configuration of Excel |