Find the Last Row, Column, or Cell in Excel VBA with the SpecialCells Method (Part 3 of 3)

Find the Last Row, Column, or Cell in Excel VBA with the SpecialCells Method (Part 3 of 3)

 

 

Learn how to find the last used row, cell, or column in a worksheet using VBA. In this video I explain the Range.SpecialCells method which will help find the last used cell on the worksheet. This is different than the last non-blank cell.

 

Related Topics:

• Find the Last Row, Column, or Cell in Excel VBA with the Range.End Method (Part 1 of 3) 
• Find the Last Row, Column, or Cell in Excel VBA with the Range.Find Method (Part 2 of 3) 
• Excel Keyboard Shortcuts to Select Column with Blank Cells 
• Excel SumIfs, CountIfs, AverageIfs Analyze and Filter Add-in