Hi!
Is it possible to have a macro that creat a new sheet and puts it first in
the workbook like this:

I have one sheet named: kvartal1
The macro creats a sheet named kvartal2. If I run it again it creats
kvartal3... and so on.

This might work for you:

'+++++++++++++++++++++++++
Dim mySheet As Worksheet
Set mySheet = Sheets.Add(Sheets(1))
mySheet.Name = "Kvartal" & Sheets.Count
'+++++++++++++++++++++++++

Rgds
J

On Oct 18, 1:36 pm, Calle <C...@discussions.microsoft.com> wrote:
> Hi!
> Is it possible to have a macro that creat a new sheet and puts it first in
> the workbook like this:
>
> I have one sheet named: kvartal1
> The macro creats a sheet named kvartal2. If I run it again it creats
> kvartal3... and so on.

hi!
it get named "kvartal 10" since I also have many other sheets. Any other
suggestion

Regards Calle

Dim mySheet As Worksheet
Set mySheet = Sheets.Add(Sheets(1))
mySheet.Name = "Kvartal" & Sheets.Count - 9

--
Regards,
Tom Ogilvy


"Calle" <(E-Mail Removed)> wrote in message
news:8334BF93-3854-4662-83A9-(E-Mail Removed)...
> hi!
> it get named "kvartal 10" since I also have many other sheets. Any other
> suggestion
>
> Regards Calle