Thread: GoToEnd Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil H[_2_] Phil H[_2_] is offline
external usenet poster
 
Posts: 87
Default GoToEnd Macro

I need the screen to show the last row of data, with cell A of that row
selected - but this macro isn't doing it. Can someone help?

Sub GoToEnd()
Application.ScreenUpdating = False
ActiveCell.SpecialCells(xlLastCell).Select
ActiveWindow.ScrollColumn = 1
Application.ScreenUpdating = True
End Sub