creatin new sheet macro
 

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.

creatin new sheet macro
 

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 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.

creatin new sheet macro
 

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

Regards Calle

creatin new sheet macro
 

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

--
Regards,
Tom Ogilvy


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

Regards Calle