Requirements: - Basic knowledge of vba - Use of tables/named ranges When working with workbooks on and off, sometimes months between revisits t...
In this article, we will create a custom function to generate random decimal numbers between the defined ranges. Raw data for this example consists o...
When you print documents from Word with VBA it's possible to select which printer tray the document is supposed to get a sheet from. In Excel you don...
The macro below can be used to print the pages of a worksheet in reverse order. Sub PrintInReverseOrder() Dim TotalPages As Long, p As Long Tot...
If you select multiple cell ranges on one sheet and tries to print out selected cells you will get one sheet for each of the selected areas. The fol...
The function below will return the user name for the logged on user, works in both Windows NT and Windows95/98. Public Declare Function GetUserName L...
In this article, we will create a macro to print all the Excel files within a folder. We have some Excel files within a folder which we want ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
