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.
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.
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]
Get the Python code snippet to check whether the string passed as parameter is Palindrome or not.
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]
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 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
Excel compare two columns & highlight the duplicates or unique values. This is a simple built in option available in conditional formatting to change the background of duplicate or unique values in the selected range of values.
Worksheet Date & Time – How to Split it? In worksheet type this function to get Time enter the formula ‘=Now()’ . It will return the default value as today’s date & time in the cell. Something like this. ‘5/7/2018 13:53’ You can see that there is a Date part… [Continue Reading]
How To Find Number of days between Two Dates? Sometimes we need to know the exact time gap or days in between two consecutive years or months. Here you will find how to find this difference in: Worksheet Excel VBA Macro code 1. Worksheet Find Days between 2 Dates Simplest… [Continue Reading]
Excel – Add Days to Date – Excluding weekends & holidays. This formula & VBA function will add workdays to a start date & give the end date to plan for your project or task.