software

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

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
www.rondebruin.nlquot;Bonbonquot; gt; wrote in message ...
gt; Is there any way to select the last Worksheet, other than clicking on the
gt; Last Tab?
gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt;
gt; Please help, i've been trying and trying =(
gt; Thx in advance
gt;
gt; Bonbon
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

quot;Ron de Bruinquot; wrote:

gt; Hi Bonbon
gt;
gt; You can use this if you have only worksheets in your workbook
gt;
gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;
gt; To select
gt; Worksheets(Worksheets.Count).Select
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt; gt; Last Tab?
gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt; gt;
gt; gt; Please help, i've been trying and trying =(
gt; gt; Thx in advance
gt; gt;
gt; gt; Bonbon
gt;
gt;
gt;

Ron has given you some code for a macro .I know that ctrl held down while
pressing page up or page dpwn selects the next or previous worksheet,i dont
know if there is a keyboard shortcut to jump to the last sheet the gt;l symbol
on the bottom left tab will take you to the last tab if it isnt showing on
the screen
--
paul
remove nospam for email addy!
quot;Bonbonquot; wrote:

gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt; you sort of make it clearer what you wanted me to do? thanks
gt;
gt; Bonbon
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt; gt; Hi Bonbon
gt; gt;
gt; gt; You can use this if you have only worksheets in your workbook
gt; gt;
gt; gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; gt;
gt; gt; To select
gt; gt; Worksheets(Worksheets.Count).Select
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards Ron de Bruin
gt; gt; www.rondebruin.nl
gt; gt;
gt; gt;
gt; gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt; gt; gt; Last Tab?
gt; gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt; gt; gt;
gt; gt; gt; Please help, i've been trying and trying =(
gt; gt; gt; Thx in advance
gt; gt; gt;
gt; gt; gt; Bonbon
gt; gt;
gt; gt;
gt; gt;

Hi Bonbon

gt;gt; gt; 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
www.rondebruin.nlquot;Bonbonquot; gt; wrote in message ...
gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt; you sort of make it clearer what you wanted me to do? thanks
gt;
gt; Bonbon
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi Bonbon
gt;gt;
gt;gt; You can use this if you have only worksheets in your workbook
gt;gt;
gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt;
gt;gt; To select
gt;gt; Worksheets(Worksheets.Count).Select
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt;gt; gt; Last Tab?
gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt;gt; gt;
gt;gt; gt; Please help, i've been trying and trying =(
gt;gt; gt; Thx in advance
gt;gt; gt;
gt;gt; gt; Bonbon
gt;gt;
gt;gt;
gt;gt;
Hi Ron,
Yes your right, i am using macros =)
I understand what you mean now, but i just know where to enter the quot;And this
will select the last worksheet
Worksheets(Worksheets.Count).Selectquot; but i dont know where to put the 1st
code.
I tried putting it after the 'select last sheet' but it didnt come out
right. Also if i was to insert 5 sheets; what should i change the code to?

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

Please help =( , would it be better if i paste my macro code for u? so you
kno exactly where im goin rong?

Bonbon
quot;Ron de Bruinquot; wrote:

gt; Hi Bonbon
gt;
gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last
gt; You used code you say that's why I posted code
gt;
gt; This line will add a worksheet at the end
gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;
gt; And this will select the last worksheet
gt; Worksheets(Worksheets.Count).Select
gt;
gt; Have you try this?
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt; gt; you sort of make it clearer what you wanted me to do? thanks
gt; gt;
gt; gt; Bonbon
gt; gt;
gt; gt; quot;Ron de Bruinquot; wrote:
gt; gt;
gt; gt;gt; Hi Bonbon
gt; gt;gt;
gt; gt;gt; You can use this if you have only worksheets in your workbook
gt; gt;gt;
gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; gt;gt;
gt; gt;gt; To select
gt; gt;gt; Worksheets(Worksheets.Count).Select
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards Ron de Bruin
gt; gt;gt; www.rondebruin.nl
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt; gt;gt; gt; Last Tab?
gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt; gt;gt; gt;
gt; gt;gt; gt; Please help, i've been trying and trying =(
gt; gt;gt; gt; Thx in advance
gt; gt;gt; gt;
gt; gt;gt; gt; Bonbon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Hi again Ron,
Thank you so much, you code was alot of help to me =D
all i did was just entered it 5 times to add 5 sheets lol.

However theres another problem i came across. Copying the E1 cell and
pasting it as the name of the sheet. Is there a code for this? because when i
record it as a macro, it keeps on copying the actual name of the cell. e.g.
sheet 1, E1 = M-13.06.05, so on the next week (M-20.06.05) it continues to
copy the last M-13.06.05.
I checked on the macro, and it says copy M-13.06.05, i want it to copy the
things inside the cell E1.

Pls help
Thx in advance,
Bonbon

quot;Ron de Bruinquot; wrote:

gt; Hi Bonbon
gt;
gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last
gt; You used code you say that's why I posted code
gt;
gt; This line will add a worksheet at the end
gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;
gt; And this will select the last worksheet
gt; Worksheets(Worksheets.Count).Select
gt;
gt; Have you try this?
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt; gt; you sort of make it clearer what you wanted me to do? thanks
gt; gt;
gt; gt; Bonbon
gt; gt;
gt; gt; quot;Ron de Bruinquot; wrote:
gt; gt;
gt; gt;gt; Hi Bonbon
gt; gt;gt;
gt; gt;gt; You can use this if you have only worksheets in your workbook
gt; gt;gt;
gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; gt;gt;
gt; gt;gt; To select
gt; gt;gt; Worksheets(Worksheets.Count).Select
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards Ron de Bruin
gt; gt;gt; www.rondebruin.nl
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt; gt;gt; gt; Last Tab?
gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt; gt;gt; gt;
gt; gt;gt; gt; Please help, i've been trying and trying =(
gt; gt;gt; gt; Thx in advance
gt; gt;gt; gt;
gt; gt;gt; gt; Bonbon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Hi

Don't know if I understand you correct but this will add a sheet and name it as the cell E1 in quot;Sheet1quot;

Worksheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = quot;M-quot; amp; Format(Sheets(quot;Sheet1quot;).Range(quot;E1quot;).Value, quot;dd.mm.yyquot;)--
Regards Ron de Bruin
www.rondebruin.nlquot;Bonbonquot; gt; wrote in message ...
gt; Hi again Ron,
gt; Thank you so much, you code was alot of help to me =D
gt; all i did was just entered it 5 times to add 5 sheets lol.
gt;
gt; However theres another problem i came across. Copying the E1 cell and
gt; pasting it as the name of the sheet. Is there a code for this? because when i
gt; record it as a macro, it keeps on copying the actual name of the cell. e.g.
gt; sheet 1, E1 = M-13.06.05, so on the next week (M-20.06.05) it continues to
gt; copy the last M-13.06.05.
gt; I checked on the macro, and it says copy M-13.06.05, i want it to copy the
gt; things inside the cell E1.
gt;
gt; Pls help
gt; Thx in advance,
gt; Bonbon
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi Bonbon
gt;gt;
gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last
gt;gt; You used code you say that's why I posted code
gt;gt;
gt;gt; This line will add a worksheet at the end
gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt;
gt;gt; And this will select the last worksheet
gt;gt; Worksheets(Worksheets.Count).Select
gt;gt;
gt;gt; Have you try this?
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt;gt; gt; you sort of make it clearer what you wanted me to do? thanks
gt;gt; gt;
gt;gt; gt; Bonbon
gt;gt; gt;
gt;gt; gt; quot;Ron de Bruinquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi Bonbon
gt;gt; gt;gt;
gt;gt; gt;gt; You can use this if you have only worksheets in your workbook
gt;gt; gt;gt;
gt;gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt; gt;gt;
gt;gt; gt;gt; To select
gt;gt; gt;gt; Worksheets(Worksheets.Count).Select
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Regards Ron de Bruin
gt;gt; gt;gt; www.rondebruin.nl
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt;gt; gt;gt; gt; Last Tab?
gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt;gt; gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt;gt; gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Please help, i've been trying and trying =(
gt;gt; gt;gt; gt; Thx in advance
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Bonbon
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
Thanks so much Ron, it works =)
sorry but i have one more problem lol. Now that the weekdays are out of the
way, i need a macro to rename the weekly sales sheet. This sheet has to be
named like this WSR-13.06.05 - 17.06.05
And in the E1:F1 cell it has 13.06.05 - 17.06.06
i tried this macro, but didnt work:
Sheets(quot;Sheet6quot;).Select
Sheets(quot;Sheet6quot;).Name = quot;WRSquot; amp;
Format(Sheets(quot;Sheet6quot;).Range(quot;E1:F1quot;).Value, quot;dd.mm.yy - dd.mm.yyquot;)

pls help again =)
Thx in advance,
Bonbon

quot;Ron de Bruinquot; wrote:

gt; Hi
gt;
gt; Don't know if I understand you correct but this will add a sheet and name it as the cell E1 in quot;Sheet1quot;
gt;
gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; ActiveSheet.Name = quot;M-quot; amp; Format(Sheets(quot;Sheet1quot;).Range(quot;E1quot;).Value, quot;dd.mm.yyquot;)
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt; Hi again Ron,
gt; gt; Thank you so much, you code was alot of help to me =D
gt; gt; all i did was just entered it 5 times to add 5 sheets lol.
gt; gt;
gt; gt; However theres another problem i came across. Copying the E1 cell and
gt; gt; pasting it as the name of the sheet. Is there a code for this? because when i
gt; gt; record it as a macro, it keeps on copying the actual name of the cell. e.g.
gt; gt; sheet 1, E1 = M-13.06.05, so on the next week (M-20.06.05) it continues to
gt; gt; copy the last M-13.06.05.
gt; gt; I checked on the macro, and it says copy M-13.06.05, i want it to copy the
gt; gt; things inside the cell E1.
gt; gt;
gt; gt; Pls help
gt; gt; Thx in advance,
gt; gt; Bonbon
gt; gt;
gt; gt; quot;Ron de Bruinquot; wrote:
gt; gt;
gt; gt;gt; Hi Bonbon
gt; gt;gt;
gt; gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last
gt; gt;gt; You used code you say that's why I posted code
gt; gt;gt;
gt; gt;gt; This line will add a worksheet at the end
gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; gt;gt;
gt; gt;gt; And this will select the last worksheet
gt; gt;gt; Worksheets(Worksheets.Count).Select
gt; gt;gt;
gt; gt;gt; Have you try this?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards Ron de Bruin
gt; gt;gt; www.rondebruin.nl
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt;gt; gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt; gt;gt; gt; you sort of make it clearer what you wanted me to do? thanks
gt; gt;gt; gt;
gt; gt;gt; gt; Bonbon
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Ron de Bruinquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Hi Bonbon
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; You can use this if you have only worksheets in your workbook
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; To select
gt; gt;gt; gt;gt; Worksheets(Worksheets.Count).Select
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Regards Ron de Bruin
gt; gt;gt; gt;gt; www.rondebruin.nl
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt; gt;gt; gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt; gt;gt; gt;gt; gt; Last Tab?
gt; gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt; gt;gt; gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt; gt;gt; gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Please help, i've been trying and trying =(
gt; gt;gt; gt;gt; gt; Thx in advance
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Bonbon
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

If E1 = 13.06.05 and F1 = 17.06.05

Then use this

With Sheets(quot;Sheet6quot;)
.Name = quot;WRS quot; amp; Format(.Range(quot;E1quot;).Value, quot;dd.mm.yyquot;) _
amp; quot; - quot; amp; Format(.Range(quot;F1quot;).Value, quot;dd.mm.yyquot;)
End With--
Regards Ron de Bruin
www.rondebruin.nlquot;Bonbonquot; gt; wrote in message ...
gt; Thanks so much Ron, it works =)
gt; sorry but i have one more problem lol. Now that the weekdays are out of the
gt; way, i need a macro to rename the weekly sales sheet. This sheet has to be
gt; named like this WSR-13.06.05 - 17.06.05
gt; And in the E1:F1 cell it has 13.06.05 - 17.06.06
gt; i tried this macro, but didnt work:
gt; Sheets(quot;Sheet6quot;).Select
gt; Sheets(quot;Sheet6quot;).Name = quot;WRSquot; amp;
gt; Format(Sheets(quot;Sheet6quot;).Range(quot;E1:F1quot;).Value, quot;dd.mm.yy - dd.mm.yyquot;)
gt;
gt; pls help again =)
gt; Thx in advance,
gt; Bonbon
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Don't know if I understand you correct but this will add a sheet and name it as the cell E1 in quot;Sheet1quot;
gt;gt;
gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt; ActiveSheet.Name = quot;M-quot; amp; Format(Sheets(quot;Sheet1quot;).Range(quot;E1quot;).Value, quot;dd.mm.yyquot;)
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt; Hi again Ron,
gt;gt; gt; Thank you so much, you code was alot of help to me =D
gt;gt; gt; all i did was just entered it 5 times to add 5 sheets lol.
gt;gt; gt;
gt;gt; gt; However theres another problem i came across. Copying the E1 cell and
gt;gt; gt; pasting it as the name of the sheet. Is there a code for this? because when i
gt;gt; gt; record it as a macro, it keeps on copying the actual name of the cell. e.g.
gt;gt; gt; sheet 1, E1 = M-13.06.05, so on the next week (M-20.06.05) it continues to
gt;gt; gt; copy the last M-13.06.05.
gt;gt; gt; I checked on the macro, and it says copy M-13.06.05, i want it to copy the
gt;gt; gt; things inside the cell E1.
gt;gt; gt;
gt;gt; gt; Pls help
gt;gt; gt; Thx in advance,
gt;gt; gt; Bonbon
gt;gt; gt;
gt;gt; gt; quot;Ron de Bruinquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi Bonbon
gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last
gt;gt; gt;gt; You used code you say that's why I posted code
gt;gt; gt;gt;
gt;gt; gt;gt; This line will add a worksheet at the end
gt;gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt; gt;gt;
gt;gt; gt;gt; And this will select the last worksheet
gt;gt; gt;gt; Worksheets(Worksheets.Count).Select
gt;gt; gt;gt;
gt;gt; gt;gt; Have you try this?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Regards Ron de Bruin
gt;gt; gt;gt; www.rondebruin.nl
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt;gt; gt; Sorry im like a beginner to Excel, and i dont understand what you mean, could
gt;gt; gt;gt; gt; you sort of make it clearer what you wanted me to do? thanks
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Bonbon
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Ron de Bruinquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; Hi Bonbon
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; You can use this if you have only worksheets in your workbook
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Worksheets.Add after:=Worksheets(Worksheets.Count)
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; To select
gt;gt; gt;gt; gt;gt; Worksheets(Worksheets.Count).Select
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; --
gt;gt; gt;gt; gt;gt; Regards Ron de Bruin
gt;gt; gt;gt; gt;gt; www.rondebruin.nl
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; quot;Bonbonquot; gt; wrote in message ...
gt;gt; gt;gt; gt;gt; gt; Is there any way to select the last Worksheet, other than clicking on the
gt;gt; gt;gt; gt;gt; gt; Last Tab?
gt;gt; gt;gt; gt;gt; gt; Because i created a macro which inserts more sheets after the Last Sheet,
gt;gt; gt;gt; gt;gt; gt; but that Last Sheet is named (lets call it LS), so everytime the macro runs
gt;gt; gt;gt; gt;gt; gt; it inserts new sheets after the LS sheet, rather than the 'real' last sheets.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Please help, i've been trying and trying =(
gt;gt; gt;gt; gt;gt; gt; Thx in advance
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Bonbon
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;