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
Author Archives: AlanP
Automatically Changing Named Ranges
Reply
Automatically changing named ranges can save you time, avoiding the need to manually change the chart data range as new data is added, for example, for monthly reports. The key to this is using the OFFSET function when defining the name. Continue reading
Sum with Conditions
Use SUMIF and SUMIFS to sum with conditions. Learn how to use different types of conditions including dates and multiple criteria for a single range.
Continue reading
Data Tables
Excel data tables are a useful way to show how calculated results depend on one or two variables. There are two types of data tables: one-way data tables which have only one variable changing and two-way data tables which have two variables changing. Let’s find out how to create each type.
Continue reading
Named Ranges
You can create names for a range of cells. (A range consists of one or more cells on a worksheet.) These names can be used in formulas and functions wherever a reference to a range can be used. Using named ranges makes things more understandable, especially if others need to look at your Excel files and use them. It also reduces the chance of making an error in your calculations.