Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Macro VBA Tip 15 - Combine the Range and Cells Property in Excel Macros

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
6,035
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 3, 2009

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

Use the Range and Cells selection properties together in Microsoft Excel Macros. This is a great tutorial for any beginner in Excel Macros and VBA. You will learn how to use the Cells property inside of the Range property so that you can use variables and numbers inside of the Range property instead of regular A1 style cell references. This method allows you to make your Macros much more versatile, dynamic, and powerful than just using the Cells or the Range property alone. Also, you can easily include variables within the Cells property for cell references.

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!

  • likes, 1 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • I LOVE YOU FOR THIS, YOU SAVED MY LIFE.HA

  • you are a excel genius

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more