Tag: VBA Intermediate

Select Non Blank cells of ActiveSheet

If you want to replace or select non-blank cells on the particular columns in active sheet, use the below codes: 

  Input: I have selected Non blank cells on the Active Sheet and replaced with 1. Result:

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

#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