Header/Footer

stone · May 19th, 2002, 10:53 AM

Hi guys.

Can I put a little picture ( a logo) in the header. (File-Page setup-Header/footer).

And can a put the value that is in cell A1 in my worksheet, in my header.?

BK
Stulli

Paul B · May 19th, 2002, 01:29 PM

I don’t know about a picture but this will put what’s in cell A1 in the left hand header
Sub header()
With ActiveSheet.PageSetup
.LeftHeader = ActiveSheet.Range("A1")
End With
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 10:53 AM	#1
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Hi guys. Can I put a little picture ( a logo) in the header. (File-Page setup-Header/footer). And can a put the value that is in cell A1 in my worksheet, in my header.? BK Stulli

May 19th, 2002, 01:29 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	I don’t know about a picture but this will put what’s in cell A1 in the left hand header Sub header() With ActiveSheet.PageSetup .LeftHeader = ActiveSheet.Range("A1") End With End Sub