Hi,

I didn't try this, but intersecting your "Export" range
with Application.UsedRange should work (although might be
slow if the used range is huge).

Happy programming!

Dag
)


-----Original Message-----
Hello,

I have an excel table that gets refreshed on monthly
basis. I also have set up a macro in Access to append
each new monthly table from excel to an Access table.

The range that I import in Access is named "Export". What
I would like to be able to do is set the "Export" range
to include only rows that are filled with data. The
fields are always the same and the first field is numeric
so I can use the count formula to map the end row. (I am
aware that I can import the whole spreadsheet in access
but the first 6 rows in the excel spreadsheet are not to
be imported.)
Any ideas?
Thank you again for your help.
Diana


.