>>Hi I have to import a lot of Excel spreadsheet data into dbf and need to read records row by row
>>
>>Is there a excel command to get the number of active rows and columns in a sheet?
>>
>
>Check out the UsedRange property.
>
>Tamar


So I checkt it out. But I cannot fnd a property like OUsedRange.rowcount or OUsedRange.Columncount anywhere (not in your book nor in the VBA help in excel

Also before a paste (from a _vfp.DataToClip(,,3) ) how can i select the cell(6,1) for example ?

Thanks in advance

Peter