Hi,
I column "A", I have a list of named ranges. In another column, I want to paste into the cell the named range in that row
I have 100 rows, and use a simple loop to pass through the rows. However I cannot get the content of the reference cell into the formula of the other?
Should I be using a copy/paste command instead? - Can't get that to work either..
Dim I as integer
I = 1
Loop
End Sub
Thanks in advance!
I column "A", I have a list of named ranges. In another column, I want to paste into the cell the named range in that row
I have 100 rows, and use a simple loop to pass through the rows. However I cannot get the content of the reference cell into the formula of the other?
Should I be using a copy/paste command instead? - Can't get that to work either..
Dim I as integer
I = 1
Do While I < 101
Cells(i,1).value = Cells(I,2).value
I=I+1
Loop
Thanks in advance!