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. 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 …
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 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.
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 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
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.
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.
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.
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.