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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"aiyer " wrote in message
...
Hello all!

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

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

Thanks,
Arun.
Engr, Vextec.


---
Message posted from http://www.ExcelForum.com/



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.592 / Virus Database: 375 - Release Date: 18/02/2004