Download Embedded Pdf File In Excel

This question has been asked so many times but I have not seen a single working answer anywhere. This code works and is not dependant on the unreliable .InvokeVerb or the .Verb Verb:=xlPrimary method. Note: This will only work for pdf files. If there is a mix of...

Find Last Row and Last Column

There are many occasions when we want to find the last row or the last column. This post is about the Correct way to find the last row or the last column. Below mentioned are some of the most common ways of finding last row which are highly unreliable and hence should...

VBA – Control Arrays

These are the few things that we will be covering in this post: What is a Control Array? Can we create Control Arrays in VBA? Why do we need a Control Array? Examples of Control Arrays in VBA a) Using existing textboxes in the UserForm and assigning a same set of...

.Find and .FindNext

The most under utilized feature of Excel when it comes to finding data is .Find and .FindNext. Most of us use loops in case we want to find something in Excel. For Example, Let’s say Our data is in sheet1 from Cell A1 to A65000 and the data is like this A1 → 1 A2 → 2...

To ‘Err’ is Human

I am yet to see a programmer who can write flawless code and when I say flawless code I don’t mean just Sub Sample() MsgBox "Hello World!" End Sub A good code can take you places and when I mean places, I not only mean geographical regions but also various corners of...