Learn how to loop in Excel VBA for each cell in range of a worksheet. Also get its row, column numbers and values with the loop.
VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets
October 31, 2024
Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.
VBA to open or save Word document Protected or Encrypted with password
October 31, 2024
Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.
VBA Get Numbers with in a String
October 31, 2024
Excel VBA code to get all digits or numbers with a string. This function extract only the numbers from with in a string text.
VBA – Find number of Dimensions in an Array
October 31, 2024
How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.
VBA Combo box Add Items – from Excel Range or Array
October 31, 2024
VBA code to add items to Combobox Userform. Different methods to add combobox dropdown items present in a userform using the VBA code.
Run Macro from Another Workbook – Excel VBA
October 31, 2024
Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.
Excel VBA Selenium Chrome – Easy Sample Code
October 31, 2024
Install Excel VBA Selenium type library & launch Chrome browser for webdata extraction. Also other browsers like Firefox, Edge etc.,
VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
October 31, 2024
Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.
How to open VBA in Excel – Macro code editor?
October 31, 2024
Learn how to open VBA code in Excel. Get different options to open Excel macro code as per steps explained in this article.