Hi Bonbon

You can use this if you have only worksheets in your workbook

Worksheets.Add after:=Worksheets(Worksheets.Count)

To select
Worksheets(Worksheets.Count).Select


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bonbon" wrote in message ...
Is there any way to select the last Worksheet, other than clicking on the
Last Tab?
Because i created a macro which inserts more sheets after the Last Sheet,
but that Last Sheet is named (lets call it LS), so everytime the macro runs
it inserts new sheets after the LS sheet, rather than the 'real' last sheets.

Please help, i've been trying and trying =(
Thx in advance

Bonbon