Learn Excel Episode 365: Scroll Area

Posted in Companies, Podcasts on July 04, 2008


Learn Excel Episode 365: Scroll Area

Back in August, the podcast showed a trick for precenting people from going outside a certain range of the worksheet. Today, a caller points out that this setting is lost when you close and re-open the workbook. Today's postcast shows how to create a simple one-line macro using Worksheets("Sheet1").ScrollArea = "A1:J10" to ensure that the setting always comes back. Episode 365 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel