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.

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.

row() works in worksheet formulas, but isn't really used in VBA.

cells(ActiveCell.Row,"E").Select
might be what you want.

or

Cells(activeCell,5).Select

--
Regards,
Tom Ogilvy


"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.

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.