Renaming worksheets!

[aiyer]

Hello all!

I was trying to ADD & INSERT a worksheet to the existing worksheets
in a workbook and then rename the most currently added (ACTIV
WORKSHEET) to "FEV". How could I generalize the VB code for an
sheetname? Sometimes "sheet2" gets added/inserted to the existin
sheets and sometimes "sheet3" gets added unless we close th
workbook.....

Any suggestions would be greatly appreciated guys and that would b
help.

Thanks,
Arun.
Engr, Vextec

 

[Ken Wright]

Set NewSh = Worksheets.Add
NewSh.Name = "FEV"

 

[JE McGimpsey]

One way:

Worksheets.Add(After:=ActiveSheet).Name = "FEV"

 

[pfsardella]

Dim wShtNew As Worksheet
Set wShtNew = Sheets.Add(After:=Sheets(Sheets.Count))
wShtNew.Name = "YourSheetName"

HTH
Paul