Tag: VBA Tips

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:

#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