Category Archive: Intermediate

Sep 22

VBA – Turn off Auto Filter

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


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 …

Continue reading »


Feb 20

#1:Connect to Internet Explorer(IE) via VBA

VBA Intermediate:  #1:Connect to Internet Explorer(IE) via VBA Solution:  1. Using Late binding methodology create object of IE and make the visible property as true.  2. Then Navigate to your URL  Benefits:  Automate your day to day work Save your time Increase your productivity Alternatively you can watch my below video for better clarity  If …

Continue reading »


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 …

Continue reading »