Excel Macro VBA Tip 2 – Using The Range Property to Select Cells in Excel

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

This Excel Macro VBA tutorial shows you how to select a range of cells in Excel from a macro. The Visual Basic Range property is described and multiple examples are given. The examples include how to write the simple macro to select one cell, a range of cells, and a number of non-adjacent cells throughout the spreadsheet.

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

Have a great day!

(Visited 1 times, 1 visits today)

You might be interested in

Comment (9)

  1. HI, I am interested to purchase a seriess of macro tutorials that lead me especifficaly to create either a MRP or Data warehouse kanban.
    I am a professional in the Planning area and i am very interested to learn those kind of macros…
    Please reply what your suggestion for me is, I already went to the teachmsoffice page but could not find nothing like it…

    Thank you in advance…

  2. Great video! However it sucks having to pay a dollar for only 3 mins! I thought that for that much money I was going to be able to see the rest of the videos but oh surprise thats not going to be possible.


Your email address will not be published.