Useful Excel VBA Range Technique
It is common to create headings for data sheets in Excel VBA. There is an array technique that can make this a simple process. (more…)
Why Does My Pivot Table Default to COUNT?
When you drag a value column to the value section of a pivot table, sometimes the default calculation is COUNT, not SUM. This is frustrating, but easily fixed.
Print Titles
Print Titles is the term Excel uses to describe the rows and columns you want repeated when you print a sheet over multiple pages. You typically want to repeat the labels in the top row(s) and those in the left column(s) of the sheet. There is a dedicated button to define Print Titles on the Page Layout ribbon tab. You can display multiple rows and columns.
Excel VBA BeforePrint Issue
Excel has a BeforePrint event which enables you run VBA code before a document is printed. This event can also be triggered by Print Preview. But not all Print Previews are the same. (more…)