Excel – Create and add a custom Ribbon Tab (Menu)

Adding a custom tab into a specific Office document (2007+ documents) can be very useful if we need to transport, with the document, custom VBA/macro codes. Read More …

Replace Function to replace characters in a String (VBA)

Use the VBA Replace function to replace a substring of characters in a string with a new string. VBA Replace Read More …

Outlook – Replace E-mail Addresses Display Names

Scenario I need the full email address displayed when I print a sent email so that I can prove exactly Read More …