Hello all,
I need to set a range to copy data in between sheets
I have tried
[vba]set rng = Sheets(1).Range("A" & i "" & j)
set rng2 = Sheets(2).Range("A" & i "" & j)
rng.copy rng[/vba]
and
[vba]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[/vba]
but none of them works
any help would be appreciated, thanks