Where can I find help on terms like offset range and activate?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ActiveCell.Offset(range("i1").value).Activate is a line of VB code? Is this some other language? How come I can not find any of these terms in the help topics or index for visual basic? Where can I see a list of terms and their syntax?
 
Offset
Syntax

expression.Offset(RowOffset, ColumnOffset)

They are in the Excel VB editor help file. Offset is not listed but ask the
assistant and it will bring up the Offset selections.
With excel open hit Alt+F11, this will open the VB editor, then search the
help file.
HTH

hal said:
ActiveCell.Offset(range("i1").value).Activate is a line of VB code? Is
Click to expand...
this some other language? How come I can not find any of these terms in the
help topics or index for visual basic? Where can I see a list of terms and
their syntax?
 
Hal,

Yes. It's a line of VBA code. Putting the cursor in ActiveCell, Offset, or
Range and pressing F1 will give a description of these terms. Note that
when you get a property description, you often have to go to the object
which this property returns. For example, the Offset property (of the
ActiveCell in this case) returns a Range object, so you're interested in the
properties or methods of a range object for the Offset property, not the
Offset property per se. In the description of the Offset property, it says
"returns a Range object" where Range is a hyperlink, so you can click that
and get the scoop on it.

Let's say I1 contains 5. Then

range("i1").Value evaluates to 5.

Offset(range("i1").Value returns a range object (cell) 5 rows down.

ActiveCell.Offset(range("i1").Value is 5 rows down from the active cell.

ActiveCell.Offset(range("i1").Value.Activate will activate the cell 5 rows
down from the active cell.


Offset is a property (of the ActiveCell object) which returns a range object
5 rows down. The Activate method is specified for this object.

So when this line is executed, it will look at I5, and move the active cell
down by that value.

Note that there can be many cells in a selection, but only one active
(white) cell.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

hal said:
ActiveCell.Offset(range("i1").value).Activate is a line of VB code? Is
Click to expand...
this some other language? How come I can not find any of these terms in the
help topics or index for visual basic? Where can I see a list of terms and
their syntax?
 
Back
Top