Okay,

Here is the code I am using could you please demonstrate how I would incorporate that into my code....


local lnRows
lnRows=oWorkBook.Worksheets(1).UsedRange.Rows

oWorkBook.Worksheets(1).Range("A1:T1").Select
oWorkBook.SaveAs(sys(5)+curdir+'upenviro3.dbf', 8)


I am trying to save Cell A + lnrows to T + lnrows, the way it is I get only the 1st row... I don't know the right syntax for A+lnrows:T+lnrows


Thanks...