It might work with an A1 style reference (didn't test it), but according to
help:

Reference Optional Variant. The destination. Can be a Range object, a
string that contains a cell reference in R1C1-style notation, or a string
that contains a Visual Basic procedure name. If this argument is omitted,
the destination is the last range you used the Goto method to select.

--

Regards,

Tom Ogilvy



"keepitcool" wrote in message
...
Loopy,

application.goto requires a range reference or a string in A1 notation.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


loopy wrote:

Hi

I am trying in VBA to goto a location using the r1c1 reference style

i have tried:

Application.Goto Reference:="R[13]C[x + 1]"
and
Application.Goto Reference:="R13C x + 1"
and
Application.Goto Reference:="R13C (x + 1)"

(x is a variable incrementing on each loop)

Help in achieving the correct solution will be greatly appreciated.

thanks


Loopy;)