Macro problem - auto fill to last active cell

[CraigieL]

Hello I am relatively new to your forum and was wondering if anyone out there could help me

I have included my macro below and it is part of a much bigger macro, however at the moment due to the part of code:

Selection.AutoFill Destination:=Range("A2:B1897")
&
Selection.AutoFill Destination:=Range("J2:J1897")

It seems to not work correctly and if the input report I have is less than the 1897 lines it returns a #n/a.

What I would like to do within this same macro is only do the steps to the last active cell in the sheet e.g. it would mean that any input report of any size would work and no errors returned.

Can anyone help me out on this one

Thanks

CL