if / then VB code

[Paul Morris]

Hi There,

Want to be able to run a macro based on what's in cell A1

So something like:

If A1 = 1, then
Range("a12").Select
....

If A1 = 2, then
Range("a13").Select
....


There's more to the macro, but just after the code that will let me do what I'm trying to. Cell A1 will only ever equal 1 or 2.

Appreciate any help.
Paul

 

[tactps]

sub macro()
if [a1].value = 1 then
[a12].select
else
[a13].select
end if
end sub

 

[tactps]

Or:
Sub macro()
[a1].Offset([a1].Value + 10, 0).Select
End Sub

 

[Zack Barresse]

Range("A" & Range("A1").Value + 11).Activate