>>See Re: Excel automation - determine last populated row in sheet Thread #885317 Message #885320.
>>
>>>In the block of code below I need to determine the RANGE of an Excel sheet. I need to know the designation of the 'LastCell'. By default I'm using 'IV64000'. But I'd like a quick way to determine the actaul one. This all works. But why Copy & Paste to unused cell! I'd like to just do the cells with data.
>>>
>><snip>
>
>Thanks Sergey,
>
>I altered what you pointed out with what Jon gave me to get what I needed.
>
>

loExcelSheet.Range("A1", loExcelSheet.Range("A1").SpecialCells(11)).Select()

>
>Thanks for the help

You're welcome.