| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to turn off Page Layout View as default view | New Users to Excel | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
| How do I view color onscreen (it shows up in print view only) | Excel Discussion (Misc queries) | |||
| column is hidden in normal view but not print view | Excel Worksheet Functions | |||
Hybrid Mode
