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.