How To Speed Up Excel VBA Macro Execution Time – Optimize?
Speed up Excel macro using these optimization technique. Using this the Excel VBA macro run time is reduced making it more faster than before.
Convert Number to String in Excel VBA Macro Code
Get the command to convert a number to string. Convert variable of data type integer/float/double to a string value, so that the assignment or IF works.
VBA Option Explicit Not Working – Solved
Is Option Explciit not working in your code as desired. Undeclared variables are not reported. Here is the fix to make Option Explicit to work as desired.
VBA to Delete File in a Folder
Get VBA code to delete file from a system folder. It uses filesystemobject.deletefile function & the VBA.kill function. Both uses the filepath as parameter.
Excel VBA Loop Thru All Defined Names
Get Excel VBA code to list all the defined names in the workbook. This code will also get the formula, comments, value along with the defined name.
Excel VBA – Create Defined Name Formula & How to Use
Creating Defined Name with Formula in Excel Defined names or Custom Formula are used to simply the long formula into a short & meaningful name. These names can be defined in Excel from Menu -> Formula -> Name Manager -> New There are four parameters to define a Name Name… [Continue Reading]
Python Program To Check Palindrome
Get the Python code snippet to check whether the string passed as parameter is Palindrome or not.
Excel Custom Number Format- Change Currency To Indian Format
Convert Number Format or Currency Format This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this. 33,32,100 and 31,10,100 – Typical Indian Currency format If we select 2 or more cells with numbers in it, Excel displays… [Continue Reading]
How To Find Smallest & Largest value in a Range in Excel?
Use this function to find the largest or smallest values from list of values from a worksheet range. The same function can be used in a Excel VBA Macro coding also.
How to get Age from Date of Birth in Excel? – Formula & VBA
How to Calculate Age from Date of birth in Excel using Excel formula & VBA Macro? This page has Formula & macro mentioned to instantly get the age in Years, Months & Days
