Macro Mondays – Remove Personal Information From Excel Using Some Simple VBA
Hi Excellers, welcome again to some more #macromonday fun. Do you need to share your Excel workbooks?. Do you need to hide the personal information attached to those workbooks.? Well, it is easy to...
VBA concatenate macro
Hello Excellers, and welcome back to another #MacroMonday#Excel tip today. Do you know if there are merged cells in your Excel worksheet?. Do you want to remove or unmerge cells all at...
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...
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 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...