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

The UK's most regular instructor-led training courses.
Training information: microsoft excel training class · Microsoft excel training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

What does Range("A1") mean

Tom has attended:
Excel Advanced course

by - delegate Tom [6 posts] (2007 Mar 14 Wed, 15:59) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Aug 22 Fri	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Aug 22 Fri	Bayswater	2	book now	£195	£205
2003/XP	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003/XP	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003/XP	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2003/XP	2008 Sep 10 Wed	Tooting	0	FULL
Full Schedule: See all 129 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: What does Range("A1") mean

by - trainer Richard platinum contributer [779 posts] (2007 Mar 16 Fri, 10:07) Reply

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.

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Four
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips