I am trying to refer to all of the cells in the column except for the title
row. I suspect that the number of rows will be growing over time, too.

"kkknie" wrote in message
...

Not sure what you're after...

To reference a cell in a column (say A), you could use:

Range("A" & i)

where i is a value from 1-35536

Or,

Cells(i, 1)

with the same i condition. I am sure there are others as well.
Clarify what you are trying to do and I'll try to give more
information.

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile:
http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=271707