excel's range item method
 

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.

excel's range item method
 

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.

excel's range item method
 

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.

excel's range item method
 

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.

excel's range item method
 

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.

excel's range item method
 

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.

excel's range item method
 

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

--
Rick (MVP - Excel)


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

excel's range item method
 

Is there an xlCurrentcell, rather than xlup?
Cheers
Sean.s
"Rick Rothstein" wrote in message
...
An "enumeration constant"? I'm not sure what that means.

--
Rick (MVP - Excel)


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

excel's range item method
 

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.

--
Rick (MVP - Excel)


"Sean Farrow" wrote in message
...
Is there an xlCurrentcell, rather than xlup?
Cheers
Sean.s
"Rick Rothstein" wrote in message
...
An "enumeration constant"? I'm not sure what that means.

--
Rick (MVP - Excel)


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