&G in Footer
But if you look at the recorded code when you insert a picture, that &G rears
its ugly head:
ActiveSheet.PageSetup.LeftHeaderPicture.Filename = _
"C:\My Pictures\mypict.JPG"
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = "&G"
Gord Dibben wrote:
Steve
Excel 2002 uses &[Picture]...................not &G
Gord Dibben MS Excel MVP
On Tue, 15 May 2007 11:14:59 -0400, "Steve"
wrote:
I'm using XL 2000, and a colleague sent me a file with &G in the footer. I
don't know what version of XL she was using, nor do I know the origin of the
workbook.
Can someone explain if this has something to do with inserting a graphic in
the footer in XL 2002?
Thanks.
--
Dave Peterson
|