>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