how to go to next row

jkpd2000 · May 22nd, 2002, 02:54 PM

say , i am in cell c2 ( but i dont know)

i want to go to cell c3

is there a function?

Juan Pablo González · May 22nd, 2002, 02:55 PM

Application.Goto Range("C3"), True

or

Range("C3").Select

DZarlengo · May 22nd, 2002, 03:10 PM

Another method is "Offset". This allows you to move the active cell no matter where you are. For example:

ActiveCell.Offset(1,0).Select

The numbers in brackets are the distance to move. The first number is Rows, the second is Columns. Therefore:

(1,0) will move 1 cell down
(0,1) will move 1 cell right
(-1,0) will move 1 cell up (negatives are OK)
(5,5) will move 5 cells right AND 5 cells down.

Note that this will not work if you try to go past the limits of the sheet. For example, if you are in Column A, you can not move a negative number of columns, since there is no columns to the left of Column A.

May 22nd, 2002, 02:55 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,758	Application.Goto Range("C3"), True or Range("C3").Select __________________ Regards, Juan Pablo González http://www.juanpg.com

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

May 22nd, 2002, 02:54 PM	#1
jkpd2000 Join Date: May 2002 Posts: 91	say , i am in cell c2 ( but i dont know) i want to go to cell c3 is there a function?

May 22nd, 2002, 03:10 PM	#3
DZarlengo Join Date: May 2002 Posts: 63	Another method is "Offset". This allows you to move the active cell no matter where you are. For example: ActiveCell.Offset(1,0).Select The numbers in brackets are the distance to move. The first number is Rows, the second is Columns. Therefore: (1,0) will move 1 cell down (0,1) will move 1 cell right (-1,0) will move 1 cell up (negatives are OK) (5,5) will move 5 cells right AND 5 cells down. Note that this will not work if you try to go past the limits of the sheet. For example, if you are in Column A, you can not move a negative number of columns, since there is no columns to the left of Column A.