Excel Insert Button is Disabled – Greyed Out – 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 – 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 – Lucky Number from Birthday – Excel App
Numerology Calculator: Use this page to calculate your lucky number based on Name numerology, Date of Birth etc., Excel app in this page will calculate your Lucky number based on these concepts.
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.
Excel VBA – Convert Column Number to English Alphabet Letter
Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.
How To Edit Worksheet in xlam – Excel Addin File?
Learn how to edit worksheets in xlam file. Simple steps to make the worksheets visible in xlam addin file. The worksheets will be hidden by default, but this option controls the visibility.
