Thread: Footer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walter Hofmann Walter Hofmann is offline
external usenet poster
 
Posts: 2
Default Footer

Hello

When using the following code in a BeforePrint subroutine, the footer is
not being updated, although the code runs without error:

With ActiveSheet.PageSetup
.LeftFooter = "&05" & strA & strC & strB & strS _
& Chr(10) & strFN
End With

What goes wrong?

Regards,
Walter Hofmann