How do I make a list in Excel automatically go to the top of the .

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

Guest

How can I make an Excel spreadsheet make a list automatically move to the top
of the column to the right of the original column when it reaches the bottom?
 
Hi
Try something like this
Private Sub WORKSHEET_CHANGE(ByVal TARGET As Range)
If ActiveCell.Row = 65536 Then
ActiveCell.Offset(-65535, 1).Select
Else
End If
End Sub
This will activate when a change is made in last row of column
you may need to change if statement to suit needs if not activecell
Tina
 
Back
Top