Hi Bonbon

Because i created a macro which inserts more sheets after the Last
You used code you say that's why I posted code

This line will add a worksheet at the end
Worksheets.Add after:=Worksheets(Worksheets.Count)

And this will select the last worksheet
Worksheets(Worksheets.Count).Select

Have you try this?


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


"Bonbon" wrote in message ...
Sorry im like a beginner to Excel, and i dont understand what you mean, could
you sort of make it clearer what you wanted me to do? thanks

Bonbon

"Ron de Bruin" wrote:

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