Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2000
Is there any VBA statement or simple code to scroll the active cell to the center of the window? (the active cell remains the same address) (or even a toolbar button to do this?) There are a number of VBA scrolling commands in the help, but they seem to be of the sort that, e.g., "take Row #n and make it the top/first row visible in the window." That doesn't seem to be very useful directly, and one would seem to have to do a lot of "calculating" to make such a command perform the desired function. With rows, setting n = current row - 5 or so would probably be "good enough," but for columns, because of their highly variable width, such an approach would likely fail miserably much of the time. Thanks in advance. Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Center across selection" rather than "Merge cells" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how do I change color of "active" cell to differentiate from rest | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
"outline active cell differently than other cells" | Excel Discussion (Misc queries) |