Setup a macro to select a specific column within the same row

[Guest]

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.

 

[Guest]

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

 

[Tom Ogilvy]

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

 

[Bernie Deitrick]

Indio,

Perhaps:

Cells(Activecell.Row,5)

to use column E of the current row?

HTH,
Bernie
MS Excel MVP