| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creatin new sheet macro
hi!
it get named "kvartal 10" since I also have many other sheets. Any other suggestion Regards Calle |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
| Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Linear Mode
