ExcelBanter - VBA question - Getting las active row number

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA question - Getting las active row number (https://www.excelbanter.com/excel-programming/295342-vba-question-getting-las-active-row-number.html)

ajliaks[_7_]

VBA question - Getting las active row number

Hi,

How can I get the number of last active row in specific sheet?

Thank

--
Message posted from http://www.ExcelForum.com

Frank Kabel

VBA question - Getting las active row number

Hi
lastrow = ActiveSheet.Cells(Rows.count, "A").End(xlUp).row

--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

How can I get the number of last active row in specific sheet?

Thanks

---
Message posted from http://www.ExcelForum.com/

All times are GMT +1. The time now is 03:21 AM.