Hi Folks I know this will be an easy one! im trying to copy a range A1:B(bottom of column) onto another work sheet from A9 down.
ive got this code
But it keeps saying that im not copying into the same size range and it wont work.![]()
Worksheets("BCIS").Range("A1:B" & Range("B2").End(xlDown).Row).Copy Worksheets(3).Range("A9:B" & Range("B2").End(xlDown).Row).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Please help
Thanks
Bookmarks