Excel VBA Introduction Part 45 - Finding the Last Used Row, Column and Cell
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here
By Andrew Gould
- There are several techniques you can use in VBA to find the last row, column or cell in a worksheet. This video shows you a range of options including using the End and Offset properties; the CurrentRegion property of a Range and the UsedRange property of a Worksheet; the LastCell option of the SpecialCells method and, finally, the trusty Find method.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
