>Got the file to save to a dbf, but only the structure. I do not know how many lines of data will be in the spreadsheet so how do I find what row to end my range in? I will always know the column but not the row....
>
>Thanks again for any help....

I'm not sure I understood.
-UsedRange returns the range used on a sheet.
-SpecialCells(xlLastCell) returns the last cell used.
-Address function return the address in different way and notations.
Cetin