Hello all,

Somewhere back I read that there is a memory leak in Excel 2000 when using .pagesetup. I believe that the workaround was to use an Excel4 macro.

How do I do this from within Excel 2000/Win98SE?

For example, the following code:

Private Sub CommandButton1_Click()
With ActiveSheet.PageSetup
.Orientation = xlPortrait
.LeftFooter = ActiveSheet.Range("A1").Value
.CenterFooter = "Printed on " & Date & " at " & Time
.RightFooter = ActiveSheet.Range("A3").Value
.BlackAndWhite = True
.Draft = False
.BottomMargin = 70
End With
ActiveSheet.PrintOut copies:=2
End Sub

Many thanks,
Mike Read