Re: Extract value in last cell of spreadsheet Excell

2004-03-10 Thread masterryo
Thanks very much, but i've never used it before : where can i find this UsedRange property of excel ?

Re: Extract value in last cell of spreadsheet Excell

2004-03-09 Thread skegsy
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.

Re: Extract value in last cell of spreadsheet Excell

2004-03-09 Thread masterryo
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.

Re: Extract value in last cell of spreadsheet Excell

2004-03-09 Thread Chris_de
You can use the UsedRange property of excel. This will give you the last cell used in your excel worksheet.