Application.goto

  • Thread starter Thread starter loopy
  • Start date Start date
L

loopy

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;
 
For absolute
Application.Goto Reference:=Cells(13, x + 1)

for relative
Application.Goto Reference:=ActiveCell.Offset(13,x+1)
 
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 said:
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 said:
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;)
Click to expand...
Click to expand...
 
Back
Top