The answer depends on how your running your loop

It could be

activecell.offset(,n) where n is the offset required from the current column

or maybe

c.offset(,n)

If you post your code it will be easier to answer

Mike

"Derrick" wrote:

whats the code that will allow me to select the row that the for loop is
currently on.. eg, if the loop starts at 1 goes to 5, and is currently
working on row 2,
i want to be using cell (column, 2) in my calcs..
thanks