On Jun 17, 2:38*pm, BoRed79 wrote:
I am getting a run time error 9 about the following peice of code:

Finalrow = Sheets("Word").Range("A65536").End(xlUp).Row

Does anyone have any suggestions about how I can fix or get round this.

Thanks.

This error generally occurs when the sheet u r trying to reference is
not there. Check if there is any space int he name of Sheet "Word"