Moving around from Active Cells

Derek_35 · Apr 30th, 2002, 05:34 PM

If I search for a word (in a macro) and it is found in cell A3, is there a way to move up/down/left/right from that cell?

Also, I am having problems with the If/else syntax.

If (x=3 OR x=10) then

That OR syntax doesnt seem to work for me...

[ This Message was edited by: Derek_35 on 2002-04-30 16:39 ]

Qroozn · Apr 30th, 2002, 05:38 PM

the macro code to move right one cell would be

activecell.select
Selection.Offset(0, 1).Select

s-o-s · Apr 30th, 2002, 05:42 PM

After your find do

Activecell.offset(row,Col)

can be + or - row numbers.

On the Or front...Try if X=3 or x = 10 without the brackets.

failing that...try highlighting OR and do F1 calling up help and reviewing the examples on the VB help.

Derek_35 · Apr 30th, 2002, 05:45 PM

I apologize for these simple questions that can be found under help. For some reason, when I installed Office XP I forgot to install the Help and my XP cd is at home 4 hours away...

Nimrod · Apr 30th, 2002, 06:35 PM

one solution is (x=3) or (x=11)
the other solution is to just drop the brackets.

Apr 30th, 2002, 05:42 PM	#3
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	After your find do Activecell.offset(row,Col) can be + or - row numbers. On the Or front...Try if X=3 or x = 10 without the brackets. failing that...try highlighting OR and do F1 calling up help and reviewing the examples on the VB help. __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

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

Apr 30th, 2002, 05:34 PM	#1
Derek_35 New Member Join Date: Apr 2002 Posts: 25	If I search for a word (in a macro) and it is found in cell A3, is there a way to move up/down/left/right from that cell? Also, I am having problems with the If/else syntax. If (x=3 OR x=10) then That OR syntax doesnt seem to work for me... [ This Message was edited by: Derek_35 on 2002-04-30 16:39 ]

Apr 30th, 2002, 05:38 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	the macro code to move right one cell would be activecell.select Selection.Offset(0, 1).Select

Apr 30th, 2002, 05:45 PM	#4
Derek_35 New Member Join Date: Apr 2002 Posts: 25	I apologize for these simple questions that can be found under help. For some reason, when I installed Office XP I forgot to install the Help and my XP cd is at home 4 hours away...

Apr 30th, 2002, 06:35 PM	#5
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	one solution is (x=3) or (x=11) the other solution is to just drop the brackets.