Find & Return The Last Used Cell On An Excel Worksheet Or Column

  • Finding the last used cell on Worksheet, or in Column, is a vital need in Excel VBA. The SpecialCells Method includes any cells that have had ANY default formatting changed, as does the UsedRange. Here is a custom function ( Custom Function ) I use often. Copy paste into a Module and Run Sub ExampleProcedure