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

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

Jim Cone
San Francisco, USA


"babycody"
<babycody.1snoea_1122177901.7913@excelforum-nospam.com>
wrote inmessage
news:babycody.1snoea_1122177901.7913@excelforum-nospam.com...

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