Can I have a list, when opening, go to first blank row in the lis.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open a worksheet,can excel automatically display the first blank row
in the list?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force a filter beyond blank rows 1
How To Have A Cell Be Blank If... 2
copy from one sheet to another and skip the blank rows 3
Having Blank Cells, etc. ? 1
Excel Protection 2
Excel Concatenate with line breaks but ignore blank cells 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top