moving cursor to the right

baz · May 1st, 2002, 07:54 AM

Thank you for your time
i am using a macro to find a name in a cell (CTRL + F)once found i need to move the cursor to the right by 2 cells (this means the cursor could be in any row )so a range address i.e C25 is no good

Jay Petrulis · May 1st, 2002, 08:16 AM

Hi,

Use .Offset(0,2) at the end of your statement where you select (or identify) the cell you "FIND"

HTH,
Jay

Iain Lewis · May 1st, 2002, 08:17 AM

IF you want to move from the active cell try :

ActiveCell.Offset(0,2)

this will move you down 0 rows & accross to the right 2 columns.

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

May 1st, 2002, 07:54 AM	#1
baz New Member Join Date: Feb 2002 Location: sandy Posts: 17	Thank you for your time i am using a macro to find a name in a cell (CTRL + F)once found i need to move the cursor to the right by 2 cells (this means the cursor could be in any row )so a range address i.e C25 is no good

May 1st, 2002, 08:16 AM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Use .Offset(0,2) at the end of your statement where you select (or identify) the cell you "FIND" HTH, Jay

May 1st, 2002, 08:17 AM	#3
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	IF you want to move from the active cell try : ActiveCell.Offset(0,2) this will move you down 0 rows & accross to the right 2 columns.