Hi all
I have an ActiveX scrollbar control on my worksheet. It has been used to create a "scrollable table". (Using the offset function, which returns the data from a range of cells that contain a data spill).
I would like the max value for the scrollbar to be a dynamic number, always referring to the currently last cell of the spilled data. Meaning that I would never be able to actually scroll down into empty cells.
Any help would be greatly appreciated!
Thanks in advance!
I have an ActiveX scrollbar control on my worksheet. It has been used to create a "scrollable table". (Using the offset function, which returns the data from a range of cells that contain a data spill).
I would like the max value for the scrollbar to be a dynamic number, always referring to the currently last cell of the spilled data. Meaning that I would never be able to actually scroll down into empty cells.
Any help would be greatly appreciated!
Thanks in advance!