» Restore the position in the window using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - General Topics in VBA
VERSION - All Microsoft Excel Versions
If you want to restore the screen picture for the user after a macro has changed the window view, you can sometimes just activate the cell that was the active cell when the macro started. This is not always successful.
The following example code will restore the windowposition just like it was when the macro started :
Dim aRow As Long, aColumn As Integer, aRange As String ' global variables
Sub RememberWindowPosition() ' run this before making changes
With ActiveWindow
aRow = .ScrollRow
aColumn = .ScrollColumn
End With
aRange = Selection.Address
End Sub
Sub RestoreWindowPosition() ' run this to restore position in the window
Range(aRange).Select
With ActiveWindow
.ScrollRow = aRow
.ScrollColumn = aColumn
End With
End Sub
Book Store:
Recommended Books:
- Marketing Plans That Work, Targeting Growth and Profitability
- Accounting Principles, with CD, 6th Edition
- Financial Risk Manager Handbook, Second Edition
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Accounting and Financial Fundamentals for Nonfinancial Executives
No comments have been submitted.

