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.

Bump.



"dim" wrote:

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.