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

microsoft excel training class - what does rangea mean

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - What does Range("A1") mean

microsoft excel training class - What does Range("A1") mean

ResolvedVersion Standard

Tom has attended:
Excel Advanced course

What does Range("A1") mean

within the following macro....

Sub monthlydeds()
'
' monthlydeds Macro
' Macro recorded 14/03/2007 by Training-3
'
' Keyboard Shortcut: Ctrl+Shift+Q
'
ActiveCell.FormulaR1C1 = "=PMT(10%/12,RC[-1],RC[-2])"
ActiveCell.Offsett(1, 0).Range("A1").Select
End Sub

RE: What does Range("A1") mean

Hi Tom

Within relative reference code

ActiveCell.Offset(1, 0) - moves the active cell down 1 row and across 0 columns from the active cell.

Range("A1").Select - this specifies the range of cells to select. In other words, just select one cell.


If you wanted to select a range of cells 2x2 starting one cell below the currently active cell, you would use this code.

ActiveCell.Offsett(1, 0).Range("A1:B2").Select

This holds true for RELATIVE REFERENCE code.

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.