Turn off Auto Filter in Active sheet If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False Turn off Auto Filter in Table If Sheet1.ListObjects(“Table1”).ShowAutoFilter = True Then Sheet1.ListObjects(“Table1”).ShowAutoFilter = False End If
Tag: Excel Intermediate
Feb 26
#2:Compare two lists instantly
Excel Intermediate: #2:Compare two lists instantly Solution: 1. Select range in both lists 2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK Play this trick immediately to do your quick comparison instantly Benefits: No need to spend time in writing formulas /code Instant way Alternatively you can watch my below video …
Feb 19
#1:Creating Excel menus using your Sub Routine
#1:Creating Excel menus using your Sub Routine- Excel Intermediate Level Solution: 1. First make sure which Sub Routine you want to add it in a menu 2. Click > File > Options> Customize Ribbon 3. Now from the Right side Panel > Click New Tab and Name it Properly 4. From Choose Commands from drop down …