Get the Cell Reference of the Last Used Cell using VBA in Microsoft Excel

Enter the following code into VBA.

Function LastUsedCell()
Application.Volatile
LastUsedCell = ActiveCell.SpecialCells(xlLastCell).Address
End Function

To use the this Custom Function type =LastUsedCell() into any cell.

Return to Excel Exchange homepage.