I am not sure why this isnt working for me. I tried doing it with the macro recorder in Excel.

After copying a range from one worksheet I need to paste the data in another. I am trying use the GoTo function using a cell reference that appears in cell A1 of the sheet.
This reference changes, but I cant get the macro to change. it just keeps the original cell reference.

How should this be written.

Thanks,
Douglas