offsets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Offsets

Offsets

resolvedResolved · Low Priority · Version 2000

Andrew has attended:
Excel VBA Intro Intermediate course

Offsets

When are offsets used?

Edited on Mon 4 Aug 2008, 15:53

RE: Offsets

Hi Andrew

Thank you for your question

The offset method of the range object is used to move to or otherwise identify a cell in a specific relative position to another cell.

For example

Range("A1").Offset(1,1).Select


selects the cell one row down and two columns across from cell "A1".

Regards

Stephen


 

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.08 secs.