David Burrows wrote:

sorry Diane - I mean "no", or "I don't know"

are you refering to a range in excel?

no range is specified anywhere on the excel sheet, as far as I can
see - (I went looking for that when it went wrong)

You can't import from an Excel spreadsheet without using a named range that
covers the items you're importing.
--
Brian Tillman [MVP-Outlook]