Indio,

Perhaps:

Cells(Activecell.Row,5)

to use column E of the current row?

HTH,
Bernie
MS Excel MVP

"IndioP" wrote in message
...
How would I setup a macro to select a different cell column within the
same
row? I know that I can use the ROW() function to identify the current
row.
But I'd like to setup a macro that would goto, let's say, column E of the
current row. I've tried concatenating, using formaulaes like "EROW()", "E
+
ROW()", "$E$ROW()" and more but nothing seems to work for me. The idea
being
that regardless of current cell, I can make select a specific column
within
the same row for cell data replacement purposes.