VBA-Excel

Filter Table Over 10,000 Rows

Filter Table Over 10,000 Rows with Custom Input in Excel

If you’re working with a large amount of data which is over 10,000 rows in Excel and you need to filter it then it can be a very tricky thing to do as you will find out. Excel limits the amount of information that you can see in the filter section for a table, but with using VBA you can filter table data over 10,000 rows easily and even do so with a custom input.

Excel VBA Call Macro

VBA Excel – Call Macro Inside Existing VBA Code No.3

Recording a macro inside Excel VBA is a fairly easy task, you simply go to your developer tab and click “Record Macro” complete the function you wish to do such as clear a table or copy and paste certain cells and then stop the macro. I recently came across an issue however, I was writing a VBA script to upload another Excel document into a sheet, but once that was completed I wanted to do …

VBA Excel – Call Macro Inside Existing VBA Code No.3 Read More »

VBA Excel – Creating A Reset Button – No.2

In a previous blog I mentioned that I was going to be starting to learn VBA (Visual Basic Applications), the language used by Microsoft Excel to develop tools and other cool time saving techniques. If you haven’t a clue what I am talking about then refer to my first blog, which you can find here. Right let’s get started, I didn’t want to just start off with something extremely basic that has no real use …

VBA Excel – Creating A Reset Button – No.2 Read More »

VBA Visual Basic Application

VBA Excel: Starting Point – What Is VBA

I’ve always been interested in different coding languages, learning all about HTML, CSS, Javascript and so on, but I’ve never had time to fully perfect any of my skills in these languages. I’ve read a lot about creating SEO tools through Microsoft Excel using their own developed language, VBA, which stands for Visual Basic Applications, and it’s a subject that I really want to learn more about. Therefore I had an idea, since I usually …

VBA Excel: Starting Point – What Is VBA Read More »