ANmarS - Portfolio - HoScrollArea

Excel/VBA expert since Sep 1997 (19 years 7 months)

HoScrollArea    Added: 9/18/2011 | Created: 9/9/2011   



Scroll area inside Excel sheet, using formulas and slide bar to navigate through any 4 columns and 500 rows in a large table in another sheet. You just need to type in the sheetname, first cell and decide what 4 columns to show using thier offsets of first cell, needs to have Automatic Calculation.
Zip file has two versions, XLS and XLSX


Download (486.6 KB)

1054 downloads | Last updated: 1/15/2014


Screen shots (11)