Showing activecell in view

[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

 

[Guest]

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.

 

[Guest]

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...

 

[Ron de Bruin]

Hi Daniel

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

Or this
Application.Goto Range("E10"), True

 

[Guest]

well sure jim if you want to do it the EASY way lol

 

[Guest]

Sorry in your case with the entire row selected you want

activecell.entirerow.show

So obvious that even I missed it...

 

[Guest]

Thanks all! I guess I'll go with Jim's solution...

Daniel

 

[Guest]

Easy nothin... even I got it wrong... Come to think of it my getting it
wrong is not much of a stretch...