copyt
07-19-2012, 06:28 AM
Hello all,
I need to set a range to copy data in between sheets
I have tried
set rng = Sheets(1).Range("A" & i ":D" & j)
set rng2 = Sheets(2).Range("A" & i ":D" & j)
rng.copy rng
and
set rng = sheets(1).range(cells(i,1),cells(j,4))
set rng2 = sheets(2).range(cells(i,1),cells(j,4))
rng.copy rng
but none of them works
any help would be appreciated, thanks
I need to set a range to copy data in between sheets
I have tried
set rng = Sheets(1).Range("A" & i ":D" & j)
set rng2 = Sheets(2).Range("A" & i ":D" & j)
rng.copy rng
and
set rng = sheets(1).range(cells(i,1),cells(j,4))
set rng2 = sheets(2).range(cells(i,1),cells(j,4))
rng.copy rng
but none of them works
any help would be appreciated, thanks