anyone have an idea how to scroll the activesheet so:
ActiveCell.Top is at the top of ActiveWindow.UsableHeight ??
Printable View
anyone have an idea how to scroll the activesheet so:
ActiveCell.Top is at the top of ActiveWindow.UsableHeight ??
...i got it...even better...brings activecell to top/left of window
VB Code:
ActiveWindow.ScrollRow = ActiveCell.Row ActiveWindow.ScrollColumn = ActiveCell.Column