Use this Excel formula to find the number of working days between two dates or in a year. This formula also has option to provide custom holiday list to be included in the working days calculation.
Excel VBA – Find UpperCase Word in String or Worksheet
Finding Uppercase Words in String? Use this direct method to find out whether any lengthy string has words with all Caps. For example: This line has one WORD as all caps. If a word has all letters in caps, then it might denote some important keyword. In that case, to […]
Excel Insert Button Greyed Out – Disabled – How To Enable It?
Option to enable Insert button or option in Excel. Sometimes this option gets greyed out or disappears. User wont be able to insert row or column. Try this option to Enable it back
Excel VBA – Find String in Range – Return Row – Change Background Color – Remove Duplicates
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates. Get code to perform search operation for a string in worksheet cell range. Also use the same to find duplicates, change cell color based on value, find row of search string …
Excel VBA Convert SpellNumber – Amount (Numbers) To Words – Both US & India Formats
Get Amount converted from Number to Words both in Millions & Crores format. This Excel VBA code supports different currency formats like US Dollars & Indian Rupee formats as well. Be it Millions, Billions or Lakhs Crores, this code does it all.
Excel VBA – Loop Through All Open Workbooks – Get Names
Excel VBA code to Loop through all Open Workbooks. Also, use the same code to get names of all the open workbooks. This is useful to scan though & get the properties of any number of open workbook in the current system.
Name Numerology Calculator – Excel App 1800+ Free Downloads
Use this Name Numerology Calculator to find your lucky number based on Name numerology concepts, Date of Birth etc., to decide a better name.
How To Type Subscript in Excel – Superscript Options – Excel VBA Code
How to type a subscript in Excel. Also learn to type a superscript for a part of text. This page also has macro code to convert a part of text in Excel to be subscript, superscript or strikethrough
Excel VBA – Merge Cells – Unmerge Range
Get Excel Vba code to merge cells & also to unmerge them from the code itself. The merge & unmerge is done through range or Selection objects.
Excel VBA – Convert Column Letter to Number
Get Excel VBA code to convert Column Letter to number. The Formula & Excel vba code will get column alphabet letter & return the Column number as value.