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.

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.

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.

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.

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.

is there an excel enumeration constant for the current cel?
Cheers.
Sean.
"Rick Rothstein" wrote in message
...
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.