ANmarS - Portfolio - HoScrollArea

Excel/VBA expert since Sep 1997 (20 years 10 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

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)

1093 downloads | Last updated: 1/15/2014

Screen shots (11)