How Can I Determine the Last Row in an Excel Spreadsheet?

re: How Can I Determine the Last Row in an Excel Spreadsheet?

Jeri Bergman — Tue, 16 Aug 2011 16:18:25 GMT

for some reason, when I use QTP, I get the error message: "Unable to get the SpecialCells property of the Range Class" when trying your code. Here is the code:

Set objExcelSheet =objExcel.Worksheets(1)

objExcelSheet.Activate

Set objRange = objExcelSheet.UsedRange

objRange.SpecialCells(xlCellTypeLastCell).Activate

Any ideas why?

re: How Can I Determine the Last Row in an Excel Spreadsheet?

JV — Fri, 27 May 2011 18:42:41 GMT

‘brem’ and anyone else looking for help writing scripts.

This is a blog and not really intended as customer support or scripting help. The authors are more valuable writing well thought out blog entries.

If you need help try any of a number of scripting forums set up for answering these kinds of questions.

Here is a link to one of them: www.scriptinganswers.com

re: How Can I Determine the Last Row in an Excel Spreadsheet?

Prem — Fri, 27 May 2011 16:55:11 GMT

Can you please get us the VBA script, to find the data of the last row in an new sheet.

And this should work for at least 10 different rows (Desired rows)

I would be very grateful to you...

Thanks,

Prem

re: How Can I Determine the Last Row in an Excel Spreadsheet?

Brian Franklin — Wed, 29 Sep 2010 14:57:34 GMT

This is a great addition to my "monkey code" that I am doing after exporting data from Reporting Services and then combining worksheets to one Excel workbook. Thanks!