98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
Resolved · Low Priority · Version 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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |