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

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
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.
"JLGWhiz" wrote in message
...
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.

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
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.