>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
Mike