I am trying to add another tab to create another spreadsheet to the existing.
I did know how to do this but I have forgotten! Must be an off day :o)

dim newWS as Worksheet
set newWS = ThisWorkbook.Worksheets.Add


HTH
--
AP

"booboo140184" a écrit dans le
message de ...
I am trying to add another tab to create another spreadsheet to the
existing.
I did know how to do this but I have forgotten! Must be an off day :o)

Insert/Worksheet

Regards,
Stefi

€žbooboo140184€� ezt Ã*rta:

I am trying to add another tab to create another spreadsheet to the existing.
I did know how to do this but I have forgotten! Must be an off day :o)

Hi
One way:
Right-click on an existing sheet and click Insert.

Andy.

"booboo140184" wrote in message
...
I am trying to add another tab to create another spreadsheet to the
existing.
I did know how to do this but I have forgotten! Must be an off day :o)

right click on the tabs ,choose insert,then woksheet,or on the insert menu
on main toolbar choose worksheet.If it inserts itself in the wrong place
right click directly on the tab and move it to where you want it
--
paul
remove nospam for email addy!



"booboo140184" wrote:

I am trying to add another tab to create another spreadsheet to the existing.
I did know how to do this but I have forgotten! Must be an off day :o)

Am I just a grumpy old man? This trend to speak about 'tab' when 'worksheet'
is meant is a pain in the neck. If the OP had used the right term he/she
could have entered "Insert worksheet" into Help's search and found the
answers in seconds.
Time for another coffee maybe!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"booboo140184" wrote in message
...
I am trying to add another tab to create another spreadsheet to the
existing.
I did know how to do this but I have forgotten! Must be an off day :o)