Create new Sheet by Macro

[amna77]

Hi,
Is there any way that when I run macro, it creates a sheet(a) and at the end of maco it delete that sheet.
Any Idea?
Thanks in advance

[brettvba]

try recording a macro insert a worksheet then delete that worksheet look at the code and add it to your macro!

[amna77]

No it does not work.

Sheets.Add
Sheets("Sheet10").Select
Sheets("Sheet10").Name = "b"
Range("F19").Select

it always insert Sheet1, Sheet2, and so on.
I want to sheet name as "b". becasue I am using that dummy b sheet in my codes, so at the end of maco I want to delete that sheet.
so next time when I run macro it should insert sheet b.

[bergy]

On 2002-05-16 14:24, amna77 wrote:
No it does not work.

Sheets.Add
Sheets("Sheet10").Select
Sheets("Sheet10").Name = "b"
Range("F19").Select

it always insert Sheet1, Sheet2, and so on.
I want to sheet name as "b". becasue I am using that dummy b sheet in my codes, so at the end of maco I want to delete that sheet.
so next time when I run macro it should insert sheet b.

Try this instead of the code above.

Sheets.Add
ActiveSheet.Name = "b"

[ This Message was edited by: bergy on 2002-05-16 14:37 ]

[amna77]

Thank you very much, It works.