Hi Edgar

That is useful but not quite what I want.

I have a program that needs to append rows to the end of a spreadsheet. I want to be able to open the spreadsheet and then determine what is the last used row. Someone once told me how to do this but I have lost it.

I think it has something to do with Range and BottomRightCell, but I am not to sure how to get it working, Yet.

Any pointers.

Regards
Geoff

>Geoff,
>take a look at this
>
>Re: Accessing Excel Sheet Thread #703274 Message #703291
>>Hi
>>
>>I'm sure I've asked this before but I cant seem to find it.
>>
>>How do I determine how many rows (what the data area) is in an excel spreadsheet.
>>
>>regards
>>Geoff Scott