GS wrote:
GS laid this down on his screen :
I suspect you also want to unhide all the columns after printing and
so to do so insert the following line before ending 'PrintMyCols'...

PrintRange.EntireColumn.Hidden = False

Revised code to scroll the window...
'...
PrintRange.EntireColumn.Hidden = False
With ActiveWindow
.ScrollColumn = 1: .ScrollRow = 1
End With
End Sub

Garry,

the hide/show thing works, but the main problem persists. Now it tries
to print all columns up to "AH" (same setup as before). Why "AH"? Even
more strange: setting a print area has no effect. The result is always
the same.

regards
Michael