Tom’s Tutorials For Excel: Copying Your Page Setup to Multiple Worksheets
Establishing your Page Setup preferences can involve a lot of steps. You won’t want to repeat those same steps over and over for each worksheet where you’ll want the same preferences.
To show the Page Setup dialog box…
…
Tom’s Tutorials For Excel: Entering an Ampersand in Your Header or Footer
If you’ve ever wondered why a custom header or footer does not show an ampersand (&) when you want to show it, there’s a small trick to making that happen. All it takes is two ampersands in succession,
…
Tom’s Tutorials For Excel: Formatting Cell Contents as Invisible
Here’s how you can make a cell’s contents be invisible, while keeping the cell’s rows and/or columns unhidden. In the following pair of pictures, employee salaries are in column F, but you want them hidden while column F remains visible.
…
Tom’s Tutorials For Excel: Printing Some Sheets, Not Printing Others
In some cases you want an easy way to print only certain sheets from your workbook.
There are two approaches — identifying which sheets to include, or which sheets to exclude.
Below are two macros,
…
Tom’s Tutorials For Excel: Set Page Breaks For Specified Areas
If your worksheet has areas of data that you want to print on separate pages, you can easily establish page breaks based on a wide choice of cell properties or text values. With the following macro for the pictured example,
…
Tom’s Tutorials For Excel: Count Your Workbook’s Total Printable Pages
Ever want to know how many total pages would print from all your workbook’s worksheets?
This macro will tell you:
Sub GetPrintablePageCount()
Dim iSheet%, iCountStart%, iCountEnd%
iCountStart = 0: iCountEnd = 0
For iSheet = 1 To Worksheets.Count
If Sheets(iSheet).Visible = xlSheetVisible Then
Sheets(iSheet).Activate
iCountStart = iCountEnd + 1
iCountEnd = iCountEnd + ExecuteExcel4Macro(“INDEX(GET.DOCUMENT(50),1)”)
MsgBox “The sheet named ” & Sheets(iSheet).Name & vbCrLf & _
“has its printable pages starting at number ” & iCountStart & vbCrLf & _
“and ending at number ” & iCountEnd,…
Tom’s Tips for Excel: Print a Word document from Excel
Here is the Tuesday blog length post from Tom Urtis. This one is so handy!
Sub PrintWordDoc()
‘Declare object variables.
Dim WdApp As Object, wddoc As Object
‘Open Word
Set WdApp = CreateObject(“Word.Application”)
‘Open the Word document to be printed.…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
