aiyer

You have no mention in your code of a new workbook

You add the new sheet into the same workbook that contains your vexte
sheet


If the new book is open

try changing
Set NewSh = Worksheets.Add

to

Set NewSh = workbooks("BookName").Worksheets.Add

If not open then you will need to add a new workbook before adding
new sheet or renaming sheet1 to fe

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