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

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
But it keeps saying that im not copying into the same size range and it wont work.

Please help

Thanks