View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aiyer[_3_] aiyer[_3_] is offline
external usenet poster
 
Posts: 1
Default Renaming worksheets!

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

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