Formatting in Excel seems to be a topic of interest for users at all levels of expertise. In this post I look at three different areas – formatting basics, formatting a report and formatting cells; so there should be something for everyone. Continue reading
Category Archives: 3 Advanced
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
Email from Excel Macro
Reply
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
Print in a Macro
If you need to print in a macro then there are some things that are helpful to know like how to simply print using the default printer, how to let the user select a printer and how to manage the printer port numbers. Continue reading