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
Tag Archives: Macros
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
Email Excel Sheet Macro
To email an Excel sheet using a macro is easier if your workbook or file has only one sheet. Otherwise, copy the desired sheet into a new workbook and then email that. Continue reading