I also have quite limited knowledge of Excel code but hope this helps..

In the Visual Basic screen locate "ThisWorkbook", double click to
select and the choose "Workbook" from the drop down on the main page.
This should then show

Private Sub Workbook_Open()

End Sub

The just insert this code in between...

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("B6").EntireRow.Delete Shift:=xlUp
End Sub

Where Sheet1 is the sheet you want to delete the row from.

Hope this helps

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=516209