The focus of this website is changing to equipping people to be better analysts using a variety of tools rather than exclusively Excel. It will also provide more information about my services to small and medium enterprises.
Category Archives: Macros and VBA
Macro to Select the Date
Are you looking for a macro to select the date? Recently I was looking for some type of calendar or built-in dialog box that would enable a user to select the date which I would then feed into my macro. I saw one option but that looked too involved for my purposes so I wrote my own function. Continue reading
Trim Your Selected Data
Do you find yourself having to apply Excel’s TRIM function to columns of data from another data source? The following macro will trim your selected data, i.e. remove blanks from the start or end of each cell. This method can also be adapted to other situations like formatting text or performing calculations. Continue reading
Introduction to VBA Functions
Today I introduce VBA functions using the emailing from Excel macro as my example. We will look at how functions are different to a sub, how to declare a function and how to use arguments, especially optional arguments. I conclude by outlining the steps in the emailing from Excel macro. Continue reading
Advanced Filter
Reply
There is a powerful and efficient filtering tool in Excel called Advanced Filter. In addition to filtering values, it has the option of generating a list of unique values. There is one pitfall to avoid when using this in a macro. Continue reading