Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.
How To Edit Worksheet in xlam – Excel Addin File?
Learn how to edit worksheets in xlam file. Simple steps to make the worksheets visible in xlam addin file. The worksheets will be hidden by default, but this option controls the visibility.
How To Screen Record – in IOS, iPhone, Android, Windows, Mac ?
Learn how to screen record iOS, Android, Windows, iPhone etc., using these free apps. Record screen with audio, take screen shots & save it for future references.
How to Run Macro – by Clicking Hyperlink – in Excel?
November 25, 2024
Learn how to run macro using hyperlink. Tips to assign a vba macro to a hyperlink in a Excel worksheet. no command buttons are required. Just a href is enough to trigger a macro code.
Create Keyboard Shortcut – to VBA Macro code – in Excel
Assign keyboard shortcut to Vba macro code in Excel. Once it is mapped, pressing the same combination of the keys will invoke the mapped macro & execute the code in it.
Check If Outlook is Running – then Launch Outlook app – vba code
Excel vba code to check if Outlook is already running or not in your computer. Use this code to check. If the Outlook is not running already, then use the Vba.shell command as specified to ope the app.
Convert Excel to HTML Table Tags – VBA Macro Code
Excel to HTML Table Converter App download and also get VBA Macro code that loops through Excel sheet content & convert it into a HTML Table
Excel VBA – Attach Inline Image – To Outlook Email body
VBA code to insert inline images into Outlook Email from Excel. Using CID in HTMLbody to embed images, background images in emails from Outlook
VBA Macro – Choose Outlook Email Account – To Send Mass Mail
November 25, 2024
Excel vba code to choose any Outlook Email Account to send email. Used in Mass email or bulk email services thru Outlook Email. Select from list of Email Accounts configured in your system.
Determine Operating System – Excel VBA Macro – Find OS Details
Excel Vba code to find the Os version – whether it is Windows 32 bit , Windows 64 bit or Mac IOS machine. Useful to make a code be compatible irrespective of the destination machine.