Dec 11, 2013 #1 PercyNK Programmer Nov 15, 2013 7 0 0 ZA 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
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
Dec 11, 2013 #2 S SkipVought Programmer Dec 4, 2001 47,485 7 38 US hi, Code: Debug.Print YourWorksheetObject.UsedRange.Rows.Count Skip, [sub] Just traded in my OLD subtlety... for a NUance![/sub] Upvote 0 Downvote
hi, Code: Debug.Print YourWorksheetObject.UsedRange.Rows.Count Skip, [sub] Just traded in my OLD subtlety... for a NUance![/sub]