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.
Learn how to add leading zeroes in Excel for numbers in cell. You can add zeroes to the display formats or to values with formula and few simple methods.
Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Export VCF to Excel file using Google. Load Vcard file to Excel and convert them to a CSV file. This way it is easy to import the contacts to xls file.
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.
Get Excel worksheet caption & name (or Object name or Codename) using VBA Macro. This is a readonly property and cannot be renamed using code without giving access to VBA Project Model.