How to count rows in Excel before importing into Access?

[PercyNK]

Hi All,
With reference to thread705-1167156

How do I reference the particular excel file and sheet I wish to import from.

Thanks for your help

percy

 

[SkipVought]

hi,

  Debug.Print YourWorksheetObject.UsedRange.Rows.Count

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}