Tags » Vba

VBA, How to set a name for a range valid in all sheets of the book?

I have muuliple sheets and I want to copy, say, “A2″ in one sheet and paste the value (or formula that the cell contains) in other sheets. 59 more words


VBA Training Modules

I am attaching the VBA training presentations which is segregated into 3 modules. These 3 modules will help to to understand:

Module 1:


Customising EA

In my last post I started to look at how we can access tools from within EA by customising the tools menu.  My plan was to continue looking  at accessing tools however in starting to pull together ideas for this post, I realised that I was going to be talking about stuff which may be new to some.   1,879 more words


Solver with VBA

The first VBA assignment was to design a solver template to determine the optimal supply chain route with the lowest shipping cost possible. There should be pop up message boxes and input boxes for different shipping scenarios. 244 more words


Generating and calling code on the fly: VBA delegates.

That’s one of the problems I’ve been wanting to solve in VBA for ages, but never really spent the time to actually do it. This weekend I thought I’d tackle it for real, and ended up quite quickly with a working solution. 613 more words

Excel VBA - Hide Autofilter Dropdowns

This piece of code will hide the dropdown “arrows” on cell(s) that are auto-filtered. You will want to use this if you only want to allow people to filter based on certain columns of data. 30 more words

Knowledge Base

VBA and Git

We all know that we should be using source control, but many of us don’t. For those of us working with Visual Basic for Applications, our excuse is often, “I can’t. 940 more words