Neale Blackwood CPA explains how to convert paper size.
Q.
We receive worksheets from other divisions that have the paper size set to Letter. This affects how the pages print out on A4 paper. Is there an easy way to convert all the sheets in a workbook to the A4 paper size?
A.
The macro below will adjust the paper size to A4 for every sheet in the active workbook. Sub A4Paper() Dim sht As Worksheet
For Each sht In Sheets sht.PageSetup.PaperSize = xlPaperA4 Next sht End Sub
Q.
How do you print the & (ampersand) character in the Header?
A.
The & character is used to define certain information that can be printed in Headers and Footers. To print the & character itself use &&. Hence, if you want to print Smith & Jones in the Header you would type Smith && Jones.
Neale Blackwood CPA is a senior consultant with mailbarrow.com, which provides Excel consulting services.
