Thanks very much,
but i've never used it before : where can i find this UsedRange
property of excel ?
Is this number special in any way , ie , the highest or lowest number
or unique in some way to the rest of the data ? If so,this should this
will be very easy to do.
The last row of the spreadsheet can vary from 01 to x hundreds or x
thousands and it is not possible to know it in advance, but when I
intend to work on the spreadsheet, the spreadsheet is created for some
days and is present on the computer.
You can use the UsedRange property of excel. This will give you the
last cell used in your excel worksheet.