VBA

Episode 384 – Formatting Macro

               

Someone posed this question in a recent Power Excel seminar – he had to format cells with a strange format, and had to do this repeatedly. Learn how to record a simple macro to automate this task. Episode 384 shows you how. This blog is the video podcast companion to the book, Learn Excel from(…)

Episode 365 – Scroll Area

               

Back in August, the podcast showed a trick for preventing 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(…)

Learn Excel from MrExcel