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