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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Offsets

ResolvedVersion 2000

Fri 13 Jun 2008, 15:07 Delegate Andrew said...

Andrew has attended:
Excel VBA Intro Intermediate course

Offsets

When are offsets used?

Mon 4 Aug 2008, 15:52 Edited on Mon 4 Aug 2008, 15:53 Trainer Stephen said...

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy