| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![Jim Thomlinson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
