Thread: Delete a Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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