Application.goto
 

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

Application.goto
 

For absolute
Application.Goto Reference:=Cells(13, x + 1)

for relative
Application.Goto Reference:=ActiveCell.Offset(13,x+1)

--
Regards,
Tom Ogilvy


"loopy " wrote in message
...
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/

Application.goto
 

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;)

Application.goto
 

Application.Goto Reference:="R13C" & (x + 1)

that should do it

-Gitcyphe

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

Application.goto
 

thanks very much

It did it!

appreciate

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

Application.goto
 

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;)