Thread: Moving the Active cell to the left of the screen
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
  
Posts: 2,718
Default Moving the Active cell to the left of the screen
All you need is this:

Application.Goto Sheets("Hist (2)").Cells(col, 5), True

instead of this:

With Sheets("Hist (2)")
.Activate
.Cells(1, col).Activate
End With

--
Jim Rech
Excel MVP


Reply With QuoteReply With Quote