Thanks folks, that worked a charm.

I edited it firstly to delete the row depending on the value from another
sheet in the same workbook, and I have that working ok.

But now I've been trying to get it to take the row number value from a
different workbook. I've tried different combinations but keep getting either
object or syntax errors. Here's my most recent effort of converting it to
take the other workbooks value:

Sub test()
Rows("Book3.xls".Sheet1.Cells(1, 1).Value).Delete
End Sub

The code is obviously located in a module for Book 2 (Not book 3) which has
the rows I want to delete and Book 3 is open while running the code.

I prefer to figure things out myself through trial and error, and have tried
editing this code a variety of ways, but I'm just missing something and can't
put my finger on it! Can you give me some guidance on where I'm now going
wrong with this?

Thanks.