sub selectnew
curro = activecell.row
cells(curro,columnnumberyouwanttoselct).select
end sub

"IndioP" wrote:

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.