Showing activecell in view

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

Guest

The last line of my code selects an entire row
cells(x,1).EntireRow.Select

I had hoped that this row would be in view to the user, but no, the sheet is
left where I last scrolled it to.

Can someone give me a piece of code that will scroll the sheet so that the
highlighted row is in view (if it makes a difference, I have Freeze Panes on
so that Row 1 and columns 1,2,3 are frozen)

Thanks in advance
Daniel
 
Daniel

ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollRow = x

these commands set the row you choose to the top of the screen and the
column you choose to the left.
 
Hi Daniel

Try this
ActiveWindow.ScrollRow = Cells(10, 1).Row

Or this
Application.Goto Range("E10"), True
 
Sorry in your case with the entire row selected you want

activecell.entirerow.show

So obvious that even I missed it... :)
 
Easy nothin... even I got it wrong... :) Come to think of it my getting it
wrong is not much of a stretch...
 
Back
Top