From a macro I want it to read the contents of a cell, and from that the
macro decides which cell to select.

There is a limited range of variables, so I was thinking about doing it with
something like an Else If statement, but not sure if this is possible;

Eg:
IF A1=1, select B1, if not leave cell unchanged
Else IF A1=2 select B2 etc....

I need to know the syntax for doing something like this I have tried
=IF("A18" 0,Range("A19").Select, Range("A18").Select)"
but get an error.

If anybody could tell me where I'm going wrong, show me a better way of
doing this i would be most greatful, thanks in advance.

G.