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

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

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.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• excel vba
• excel macros
• offset
• offset in excel
• how to use offset
• offset in vba
• offset macro
• range property
• offset property
• select cells with macro

[Tuberidin01]

Sorry if this sounds like a silly question. Once you've set up all the macros, you see that everything works fine when you run the macros, can you hit the tab key on your keyboard and tab around the cells (yellow, blue)?

Or do you have to first protect the sheet, then you can tab around through the cells?

[ExcelisHell]

@Tuberidin01 Yes you would have to first protect the cells

[WiresAnSteel]

Very clear, Thx, nice example using colour blocks for destinations (keeping number-clutter out for a change).

Gonna subscribe.

[stewdogg42]

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

[Melvinisawesome]

Thank you so much it is really helpful

[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.