| 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 |
| 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 | |||
Threaded Mode
