When I open a worksheet,can excel automatically display the first blank row in the list?
T Tucson Guy Jan 12, 2005 #1 When I open a worksheet,can excel automatically display the first blank row in the list?
N Norman Jones Jan 12, 2005 #2 Hi Tucson Guy, Assuming that the list is a range named "MyList", try: Sub workbook_open() Application.Goto Range("MyList").Cells(1).End(xlDown)(2) End Sub Paste this in to the workbook's ThisWorkbook module.
Hi Tucson Guy, Assuming that the list is a range named "MyList", try: Sub workbook_open() Application.Goto Range("MyList").Cells(1).End(xlDown)(2) End Sub Paste this in to the workbook's ThisWorkbook module.
