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
Tag Archives: Macros
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
Email from Excel Macro
You can email from Excel with a macro using an email address in your VBA code or in your Excel file. There are several different ways of doing this. This post looks at the one using a Windows Application Programming Interface (API) function called ShellExecute. Continue reading