Today we are going to apply a few tricks to create a genealogy chart. (I had to check my spelling – it is often misspelt as geneology and geneaology.) This is equivalent to creating a Gantt chart if you are scheduling a project. I am going to use the genealogies in the Bible in Genesis chapters 5 and 10 as my data set. Continue reading
Author Archives: AlanP
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
Count Visible Cells
Learn how to count visible cells, for example, count the number of visible rows when you filter data. Several methods are explained – not all of them work! Continue reading