Thread: &G in Footer
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default &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