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 mor
information.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=27170