moving active cell

anr20 · May 1st, 2002, 10:16 AM

i'd like to move the active cell to a specified column on the same row within a macro

s-o-s · May 1st, 2002, 10:29 AM

CurRw = Active Cell.row
NewRng = "H" & CurRw
Range(NewRng).Select

Change the H to whatever column you need

dk · May 1st, 2002, 10:29 AM

Hi,

Try this:-

Range("H" & ActiveCell.Row).Select

You'll need to change the H to the column you want the cursor to move to.

HTH,
Dan

NateO · May 1st, 2002, 10:36 AM

Yet another way to pluck a duck:

Code:

Cells(ActiveCell.Row, Columns("b").Column).Activate

DK's is easier on the keyboard.
_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-01 09:42 ]

May 1st, 2002, 10:29 AM	#2
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	CurRw = Active Cell.row NewRng = "H" & CurRw Range(NewRng).Select Change the H to whatever column you need __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

May 1st, 2002, 10:36 AM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Yet another way to pluck a duck: Code: Cells(ActiveCell.Row, Columns("b").Column).Activate DK's is easier on the keyboard. _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-01 09:42 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 10:16 AM	#1
anr20 New Member Join Date: Apr 2002 Posts: 1	i'd like to move the active cell to a specified column on the same row within a macro

May 1st, 2002, 10:29 AM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, Try this:- Range("H" & ActiveCell.Row).Select You'll need to change the H to the column you want the cursor to move to. HTH, Dan