Difference makes the DIFFERENCE
Categorised Menu List
Getting last Active Row and Last active Cell Address in Ms. Excel
The following code can be placed in any Excel file Code Window (to get Code window, Press Alt + F11) if the Code window is password protected, then it will display a Dialog box to enter password, else, it takes you to code window.
The above given code works only when the given sheet name is "Dump", but in real-time senario, you may have to get LastRowNumber or LastCellAddress of many sheets
Try using sheet name as Variable, so that it may work in any given sheet.
Row returns LONG value e.g., 104578 (to acccomodate Excel 2007 rows) and ActiveCell.Address returns STRING value e.g., $K$125