Hi,
I have this
I've tried also
but it doesn't work.
It gives me the first cell value instead of the second. Why?
I have this
where pIndex = AWorksheets("Sheet1").range("B65536").End(xlUp).Offset(1, 0) = Worksheets("Sheet2").range(pIndex & "2").Value
I've tried also
range(pIndex & "2")
but it doesn't work.
It gives me the first cell value instead of the second. Why?