This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Relative Selection using Excel VBA Macros Part one of a six-part series of blogs
This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods. Selecting Cells with Excel VBA Macros - Relative (this blog) Moving Around a Spreadsheet in VBA - Offset Selecting to the End of a Block Selecting a Block of Cells using Range Resizing Blocks of Cells in Excel VBA macros Selecting Entire Columns or Rows in Excel VBA macros This blog is part of our Excel macros online tutorial series. Wise Owl also run VBA macros courses for beginners and advanced users.

Relative Selection using Excel VBA Macros

Part one of a six-part series of blogs

This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods.

Selecting Cells with Excel VBA Macros - Relative (this blog)
Moving Around a Spreadsheet in VBA - Offset
Selecting to the End of a Block
Selecting a Block of Cells using Range
Resizing Blocks of Cells in Excel VBA macros
Selecting Entire Columns or Rows in Excel VBA macros

This blog is part of our Excel macros online tutorial series. Wise Owl also run VBA macros courses for beginners and advanced users.

Posted by Andy Brown on 16 August 2011

Selecting Cells with Excel VBA Macros - Relative

Another blog has already explained how to select cells in absolute mode; this one shows how to select cells relative to your starting point. Examples of relative selection would be:

Go down 3 cells;
Go to the end of the current block of cells;
Select from this cell down to the bottom of the block.

The VBA commands given in this blog work for Excel 2010, Excel 2007, Excel 2003 and (as far as I remember) Excel 2002, 2000 and 97 too!

If you want to try out any of the macros listed in this blog, you can download the file of Winnie the Pooh characters.

ActiveCell and Selection

Before we begin, there are two keywords which you must understand in Excel Visual Basic for Applications (VBA): ActiveCell and Selection.

In this case:

Every worksheet has an active cell, and when only one cell is selected, the active cell and selection are the same thing.

Now that we've learnt about the two key Excel VBA concepts of ActiveCell and Selection, let's look at how you can move round a spreadsheet.

Parts of this blog
Selecting Cells with Excel VBA Macros - Relative (this blog) Moving Around a Spreadsheet in VBA - Offset Selecting to the End of a Block Selecting a Block of Cells using Range Resizing Blocks of Cells in Excel VBA macros Selecting Entire Columns or Rows in Excel VBA macros

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Selecting Cells with Excel VBA Macros - Relative

ActiveCell and Selection

Head office

London

Manchester