I want to store the scroll positions and restore them at a later time. Currently, I use the WorksheetScrolled event and the ScrollCurrentWorksheet() function to accumulate the offsets to an absolute value.
However, it would be nice if I could get and set the absolute positions, because this method has its flaws. It is currently possible to get a value that is not in sync with the real absolute position when I change the number of columns, for example.
Also, being able to retrieve the maximum absolute scroll positions would be nice as well.
I was wondering what your thoughts are on this.
Thanks in advance!