I am trying to use loop to copy data from another worksheet
using subscripts in VB:
i = 12
j = 100
Cells(12, 107) = Cells(i, j)
Cells(13, 108) = "=Input1!R5C5"
Loop works fine when I use it within current worksheet
line 3. In line 4 I would like to use subscripts i,j as well,
but I don't know how to do that. Could anyone, please,
show me how to do it? I have rather limited programming
skills as you see, so please make it as simple as possible.
Les
using subscripts in VB:
i = 12
j = 100
Cells(12, 107) = Cells(i, j)
Cells(13, 108) = "=Input1!R5C5"
Loop works fine when I use it within current worksheet
line 3. In line 4 I would like to use subscripts i,j as well,
but I don't know how to do that. Could anyone, please,
show me how to do it? I have rather limited programming
skills as you see, so please make it as simple as possible.
Les