Excel Macro VBA Tip 16 - Using Offset in Excel Macros and VBA

Use the Offset property in Excel Macros. This tutorial shows you exactly how to use the Offset property to move around a spreadsheet in Excel. You will learn how to move the active cell reference up, down, left, right and all around in your Excel Worksheet. This is a great feature of Excel Macros to learn and is very powerful. You can use it with many other properties in Macros, but this tutorial shows you how to use it with the Range property. Offset in Excel.

Have a great day!

[stewdogg]

Thank you for all of your video tutorials. They are more helpful than any book I have read or website I have visited.

[johnchiemela]

i just wanna say thank you mate for these videos, i do benefit a lot from free tutorials like this one, some times i find it hard to make any sense at all of what the tutor was jabering about and here is were i get some sense of whatever its been said in class.

[TeachExcel]

@Tuberidin01 Yes you would have to first protect the cells