Hi,
I need to use VBA code to copy a line from the first worksheet to the second worksheet in the same workbook. the line would need to be pasted to the next empty line.
I downloaded a fact sheet from called Range.Copy (Bill Jenson) dated the 06/08/2017 and copied the sample code verbatim.
Unfortunately it did not work. the following line seemed to be a problem as it highlighted Yellow when I
tried to run the code.
FinalRow = Cells(Rows.Count, 1).End(x1Up).Row.
Any advise you can give me would be much appreciated as I have to use the file over our Xmas break. I am trying to learn to use VBA code, it is however a slow process.
Regards

I need to use VBA code to copy a line from the first worksheet to the second worksheet in the same workbook. the line would need to be pasted to the next empty line.
I downloaded a fact sheet from called Range.Copy (Bill Jenson) dated the 06/08/2017 and copied the sample code verbatim.
Unfortunately it did not work. the following line seemed to be a problem as it highlighted Yellow when I


FinalRow = Cells(Rows.Count, 1).End(x1Up).Row.
Any advise you can give me would be much appreciated as I have to use the file over our Xmas break. I am trying to learn to use VBA code, it is however a slow process.
Regards
