Code to scroll and return to a home position
Posted on 2011-02-11
I'm not very good at writing macros yet and was given some help. The code belows does not work. Here's my objective:
Row 5 in my spreadsheet is frozen.
In my spreadhseet R(5) C(0) I have a command button. The purpose for this to take me back to R(5) C(0) when is at other locations in my spreadsheet. I can get to my location but I havefigured out how to automatically rescroll where the spreadsheet has been restored just as if I had opened it. Here's my attempt:
Dim rng As Range
Set rng = Month Total("A5:A80").RefersTo
Set rng = Nothing