moving cursor to the right

[baz]

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]

Hi,

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

HTH,
Jay

 

[Iain Lewis]

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.