Showing activecell in view
 

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

Showing activecell in view
 

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.

"Daniel Bonallack" wrote:

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

Showing activecell in view
 

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...


"Daniel Bonallack" wrote:

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

Showing activecell in view
 

Hi Daniel

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Daniel Bonallack" wrote in message
...
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

Showing activecell in view
 

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

"Jim Thomlinson" wrote:

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...


"Daniel Bonallack" wrote:

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

Showing activecell in view
 

Sorry in your case with the entire row selected you want

activecell.entirerow.show

So obvious that even I missed it... :)

"Jim Thomlinson" wrote:

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...


"Daniel Bonallack" wrote:

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

Showing activecell in view
 

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

Daniel

"Jim Thomlinson" wrote:

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...


"Daniel Bonallack" wrote:

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

Showing activecell in view
 

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

"ben" wrote:

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

"Jim Thomlinson" wrote:

You're going to kick yourself...

Activecell.show

So obvious as to be invisible...


"Daniel Bonallack" wrote:

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