Application.CutCopyMode = False

If you use copy and paste while recording a Macro, you will see the code which refers to Application.CutCopyMode = False.  You may wonder why it’s there? The recorded code looks a bit like this: Range(“A1:A10”).Select Selection.Copy Range(“D1”).Select ActiveSheet.Paste Application.CutCopyMode = False If you use VBA to copy and paste without that line of code, Read More

Power Query – Common Errors & How to Fix Them

I’m sure you’ve not got this far without encountering your fair share of Power Query errors.  Just like Excel and other applications, Power Query has it’s own unique error messages.  You’ve probably forgotten the first time you encountered the #NAME? or #VALUE! errors in Excel, but over time you hopefully worked out what to do Read More