excel vbe scroll range - how to save?
Tools - Macro - VBE
VBE, Properties Window, Scroll Area
Ok, I set Scroll Area A1:B164, save and return to Excel spreadsheet.
Data entry works fine, cursor jumps from A1 - B1, and down to line 2, A2 -
B2, etc
Save spreadsheet, and exit.
When loading same spreadsheet, the ScrollArea is blank.
How do I save this feature?
|