excel's range item method

[Sean Farrow]

Hi:
What are the parameters for the item method of the range object?
I have understand the first two row and collumn index, what are the last two
lcid and the final string parameter?
Any help apreciated.
Sean.

 

[Rick Rothstein]

Where are you looking that you see the Item method for the Range object
having four arguments?

 

[JLGWhiz]

Same question I had, Rick. The Item method works with the collection index
as far as I can tell. I see nothing related to lcid or final string
mentioned in any of the dialog.

 

[Sean Farrow]

Hi:
in the excel 2000 type library.
Basically what I want to do, is iterate down all rows in the collumn of the
activecell on the activeshet in the active window.
Any help apreciated.
Sean.

 

[Rick Rothstein]

Your mention of "active window" and "type library" have me wondering whether
you are trying to look at different sessions of Excel running concurrently
as opposed to just looking at the active workbook within a single session of
Excel. I'll assume the latter as that would be the most logical. See if this
code does what you want...

Dim X As Long
Dim LastRow As Long
Dim ActiveCol As Long
ActiveCol = ActiveCell.Column
With ActiveSheet
LastRow = .Cells(.Rows.Count, ActiveCol).End(xlUp).Row
End With
For X = 1 To LastRow
'
' Your code goes here... use Cells(X, ActiveCol)
' to reference the cell being iterated per loop...
'
' For example: Debug.Print Cells(X, ActiveCol).Value
'
Next

 

[Sean Farrow]

is there an excel enumeration constant for the current cel?
Cheers.
Sean.

 

[Rick Rothstein]

An "enumeration constant"? I'm not sure what that means.

 

[Sean Farrow]

Is there an xlCurrentcell, rather than xlup?
Cheers
Sean.s

 

[Rick Rothstein]

I'm not sure why you are asking that particular question. There is an
ActiveCell object which is always set to the active cell (so you can find
out any Range-type information about the active cell using it), but that has
nothing to do with the xlUp constant I used as an argument to the End
method. For example, in this line...

ActiveCol = ActiveCell.Column

I used the ActiveCell object to find out what column the active cell was in.
Then in this line...

LastRow = .Cells(.Rows.Count, ActiveCol).End(xlUp).Row

used that column to search from the bottom-most cell in column... that is
what .Cells(.Rows.Count,ActiveCol) is... upward (that is what the xlUp is
for) to the first cell encountered with data in it (the first cell with data
in it traveling from the last cell in a column upward is the last cell with
data in it looking downward from Row 1 in that column). Once I had that
cell, the Row property tells me what number that row is. Then, I iterated
from the starting row to that last row which is how you would iterate the
cells individually in that column.

 

[Sean Farrow]

Hi:
Rinck within the typelibrary the declaration for the irange.Get_item method
is as follows:
function Get_Item(RowIndex: OleVariant; ColumnIndex: OleVariant; lcid:
Integer;
out RHS: OleVariant): HResult; stdcall;
What are the last two parametedrs?
Cheers
Sean.

 

[JLGWhiz]

The lcid is a Microsoft language identification code. Looks like this might
be a home work question the OP is trying to solve. The code structure posted
is not VBA code as I know it.

 

[Sean Farrow]

Hi:
it's not homework, I'm puzzled regarding the 4th parameter.
Cheers
Sean.