Adding sheet
 

Hi all,

A really basic one here but i am stumped, how do i get a macro to insert a
worksheet to the end of the workbook.

Thanks in advance

Greg

Adding sheet
 

Hello Greg,

Here's the code...

Sub AddSheet()
Worksheets.Add.Move after:=Worksheets(Worksheets.Count)
End

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=553102

Adding sheet
 

Thanks Leith


"Leith Ross" wrote
in message ...

Hello Greg,

Here's the code...

Sub AddSheet()
Worksheets.Add.Move after:=Worksheets(Worksheets.Count)
End

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=553102