Limit cells shown

  • Thread starter Thread starter caerdwyn
  • Start date Start date
C

caerdwyn

Hello,

I have a worksheet with a select number of cells I want shown.
Unfortunately in Excel you can by default theoretically scroll for
forever through the worksheet... I want to limit this. I can't find a
way to reasonably select my "content" area and "hide" every other cell
aside from those selected. Any ideas?

Thanks!
 
Maybe this will get you there. Run this in a macro to limit the scroll
area.

To limit the area:
Worksheets(1).ScrollArea = "A1:F10"

To remove the limit:
Worksheets(1).ScrollArea = ""

HTH
Regards,
Howard
 
Back
Top