Using R[1]C[1]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to copy a(n array of) value(s) inside a workbook to a location
that I refer to with the R[1]C[1] method. The [1] part should however be a
variable, which is based on a value in a certain cell, but that varies every
time. I've tried something looking like

Application.Goto Reference:= R[Range("Sheet 1!AA22")]C[69]

with the intention to move the cursor down by the value in Sheet 1!AA22,
and to the right by 69 columns.

Since this obviously doesn't work, I'm stuck. Who can help???
 
One way:

Application.Goto Reference:= "R[" & Sheets("Sheet1").Range("AA22").Value
& "]C[69]"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
setting more than one filter 1
Counting entries in column C, based on entries in column A 1
Reset my object variable myRng1 with each loop 3
R[1]C[1] with a variable 2
Column is overwritten 4
Loop Repeats - PLS HELP 2
Run macro on all files in a specific folder 3

Back
Top