If it was me, I would change the import macro so that each new sheets is
added just before the last sheet...

Worksheets.Add Befo=Sheets(Sheets.Count), Count:=1

Jim Cone
San Francisco, USA


"babycody"

wrote inmessage
...

That's kind of what I am looking for. However I never know the name of
the last sheet. New sheets are created when the number of items I am
importing from the text file excedes Excel's row limit per sheet of
65536. I was wondering if there was a way to leave this open so that
the formula automatically finds the last sheet.
--
babycody