- Dedicated trainers
- Maximum 6 per class
- Superb courseware
Phone (01457) 858877 or email
SELECTING CELLS USING EXCEL VBA MACROS - ABSOLUTE
Part one of a four-part series of blogs
This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!
- Selecting Cells in Excel Visual Basic Macros (Absolute) (this article)
- Absolute Selection - the Common Excel VBA Commands
- Selecting Rows, Columns and Entire Worksheets
- Less Common Absolute Selection Commands
This blog is part of our Excel macros online tutorial series. For real-world training, book onto our introductory or advanced VBA or Excel courses.
Selecting Cells in Excel Visual Basic Macros (Absolute)
Finding myself with a bit of spare time, I thought I'd summarise the various ways to select cells using VBA within Excel.
I've also blogged on how to select cells relative to your starting point.
This entire blog works for Excel versions 2010, 2007, 2003 and older versions. You can try any of the examples contained it by downloading this Excel workbook.
Absolute vs. Relative Selection
If you're wondering at this stage what I mean by absolute and relative selection, here's an example:
Suppose you have the orange cell selected (Pooh Bear). You want to select Tigger. If you write a macro to:
- go to cell B11, then that's absolute selection; or
- go to the bottom of the block, then that's relative selection.
The question to ask is: if I play the macro back again, does the cell it selects depend on my starting point?
I've divided the blog up into:
- Basic selection commands.
- Commands to select rows, columns and the entire worksheet.
- Unusual commands (intersections of ranges, and the like).
Enjoy!
SELECTING CELLS USING EXCEL VBA MACROS - ABSOLUTE
Part one of a four-part series of blogs
This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!
- Selecting Cells in Excel Visual Basic Macros (Absolute) (this article)
- Absolute Selection - the Common Excel VBA Commands
- Selecting Rows, Columns and Entire Worksheets
- Less Common Absolute Selection Commands
This blog is part of our Excel macros online tutorial series. For real-world training, book onto our introductory or advanced VBA or Excel courses.
Comments on this blog
This blog currently has no comments.