Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html

By Andrew Gould

https://www.wiseowl.co.uk - You won't get far in Excel VBA without understanding how to refer to cells! This fairly long video covers most of the common, and some uncommon, techniques for selecting and referring to cells. You'll learn how to select cells by cell reference using the Range property, how to refer to cells by row and column number using the Cells property, and how to refer to the currently selected cell using the Activecell property. We also cover how to select multiple cells and how to refer to range names as well as a variety of relative selection tricks such as using the End property to jump to the bottom of a list, using the Offset property to move a specific number of rows and columns, and how to select an entire region of data with one simple instruction. Along the way you'll also learn several techniques for formatting and modifying cells, as well as how to copy and paste data in VBA.

You can see written versions of our Excel VBA tutorials online at:
https://www.wiseowl.co.uk/blog/s161/online-excel-vba-training.htm

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Видео Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) канала WiseOwlTutorials