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
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
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