Excel Macro VBA Tip 13 - Select cells with the Cells Property in Excel Macros

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

Use Excel Macros to select cells with the Cells property instead of the Range property or method within Excel Macros. This method allows you to select individual cells in Excel spreadsheets using number references for columns and rows. This property acts like the range property but without using the A1 style cell references. This is a must see tutorial for beginners in writing Excel Macros.

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 macros
• free macros
• cells property
• range property
• select cells with macro
• a1 reference style

[yukernzhen]

Thanks.As a total VBA noob, I totally need a guide to get into VBA and this is a nice steady start!



[clickmaster]

You da man!