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
Excel Compare Two Columns for Duplicates – Highlight Differences
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.
How to Split Date & Time – In Excel Worksheet?
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]
Calculate Number of Days Between 2 Dates – Excel DateDiff
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]
