Discussion:
Application.goto
(too old to reply)
loopy >
2004-06-02 17:30:00 UTC
Permalink
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;

--
Message posted from http://www.ExcelForum.com
Tom Ogilvy
2004-06-02 17:38:07 UTC
Permalink
For absolute
Application.Goto Reference:=Cells(13, x + 1)

for relative
Application.Goto Reference:=ActiveCell.Offset(13,x+1)
--
Regards,
Tom Ogilvy
Post by loopy >
Hi
I am trying in VBA to goto a location using the r1c1 reference style
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;)
---
Message posted from http://www.ExcelForum.com/
loopy >
2004-06-02 17:46:18 UTC
Permalink
thanks very much

It did it!

appreciate

--
Message posted from http://www.ExcelForum.com
keepitcool
2004-06-02 17:40:24 UTC
Permalink
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 >
Post by loopy >
Hi
I am trying in VBA to goto a location using the r1c1 reference style
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;)
Tom Ogilvy
2004-06-02 17:50:25 UTC
Permalink
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
Post by keepitcool
Loopy,
application.goto requires a range reference or a string in A1 notation.
keepITcool
< homepage: http://members.chello.nl/keepitcool >
Post by loopy >
Hi
I am trying in VBA to goto a location using the r1c1 reference style
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;)
gitcypher >
2004-06-02 17:41:37 UTC
Permalink
Application.Goto Reference:="R13C" & (x + 1)

that should do it

-Gitcyphe

--
Message posted from http://www.ExcelForum.com
Loading...