Run Time Error 9
I would expect that you don't have a worksheet named Word in that workbook.
Maybe the wrong workbook is active or maybe it's a spelling error in the
worksheet name.
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.
--
Dave Peterson
|