Delete a Row
Hi Ken,
Your syntax works for me.
I tested using:
'=============
Public Sub Tester()
Const TestBookName As String = "Book2.xls"
Const RowNumber As Long = 2
Workbooks(TestBookName).Sheets(1).Rows(RowNumber). Delete
End Sub
'<<=============
---
Regards,
Norman
"Ken Hudson" wrote in message
...
I want to delete a row in a different, open workbook, but can't get the
syntax right.
Workbooks(TestBookName).Sheets(1).Rows(RowNumber). Delete
doesn't work.
--
Ken Hudson
|