Welcome to another simple #Excel macro in my #MacroMonday blog series. Today I want to show you how to write a simple Excel macro that will list all Excel worksheets in a...
Tag: Excel Tips
Formula Friday- Generate Unique User Names In Excel Using The COUNTIF Function
Happy Friday, Excellers. Today let's look at how to generate a unique username in Excel using the COUNTIF function, even when you have duplicates! Welcome back for another #FormulaFriday in...
Macro Mondays – How To Assign Or Change A Macro Shortcut Key
Hello Excellers, time for some back to basics today with Excel Macros. Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog...
Hello Excellers, welcome back to another #Exceltip blog post in my 2021 series. Today I will show you how to use flash fill to split your cells into separate columns. Yes, that is correct....
Hello Excellers, welcome back to another #Excel tip in my 2021 series. Today I will show you how to unprotect multiple Excel worksheets quickly. Have you created an Excel workbook with...
Hello Excellers, welcome back to another blog post in my #Excel #MacroMonday series. Today let's write our own Excel macro function that will generate a random string of characters. This random...