Having formulas the return errors can hurt the look and feel of your spreadsheets, check out this routine to add IFERROR to all of the formulas in a selected region! Let me know what you think! #vba #excel #code github.com/dudescott/VBAl…

Collaboration of files is very common for companies of all sizes. Use this short macro to get a link to your workbook that can be shared! #vba #excel #code #git #macros github.com/dudescott/VBAl…

Want to break cell formulas quickly? Assign this one to a keyboard shortcut! #excel #vba #macros #code #git github.com/dudescott/VBAl…

What's one of your favorite macros? I have one that renames the current file, while I'm IN the file! (Coming soon!) Share yours! #VBA #Excel #Macros #Code

Check out my code to update the file name of your current workbook! Warning: This macro involves deleting files from your folder, so please make sure you know what this is doing before using it! Contact me with questions! #vba #macro #excel #git #code github.com/dudescott/VBAl…

Ever have a workbook with a ton of sheets that are hard to navigate? Use this macro to alphabetize all the sheets in a workbook! #vba #vbalpha #code #excel #git github.com/dudescott/VBAl…

When delivering files to others, it can look more professional to not be on a random cell on each tab. Use this macro to select cell A1 on every tab! #excel #code #vba #git #macros github.com/dudescott/VBAl…

Unhide all the sheets in a workbook (even the very hidden ones)! #excel #macros #vba #code #vba github.com/dudescott/VBAl…

Retweet if VBA should be replaced with Python. Comment for JavaScript. Like for keep VBA as it is!

I've created a newsletter for my subscribers! I hope you enjoy! getrevue.co/profile/dude_s…

🔥 Hot off the press: “Issue #1: Getting Started (Featuring xlwings)” getrevue.co/profile/dude_s… (via Revue)

🔥 Hot off the press: “Issue #2: SQLite” getrevue.co/profile/dude_s… (via Revue)

Learn how to create a right click menu in Excel! getrevue.co/profile/dude_s… (via Revue)

🔥 Hot off the press: “Issue #4: Password Manager Part 1” getrevue.co/profile/dude_s… (via Revue)

Check out my Gig on Fiverr: perform data analysis and manipulation fiverr.com/share/jRjoVG