MrExcel's Learn Excel #944 - Excel to Word

Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. Episode 1152 shows you...

Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode...

Terry from Springfield, MO asks about a quicker, one-click way to change the Move Selection After Enter direction. Episode 1071 show you how to solve this problem by recording a couple of quick...

If your fiscal year does not end on December 31, then all of the cool date grouping functions available in pivot tables will not work for you. In Episode 1033, you will see how to...

While yesterday's podcast was created with the macro recorder, you can switch over to the VBA editor to change 4 lines of the macro. This will create a macro that will work without requiring you...

Laura asks how to display the Find dialog in a macro. The macro recorder won't do it. Application.Dialogs().Show won't do it. Episode 954 shows you a kludge to solve this problem. This video is the podcast...

I've talked about making the list for your data validation automatically grow with the list. In the past, I've used a macro or the OFFSET formula, but today Morne sends in a beautiful solution for...