Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 24th 06, 07:32 PM posted to microsoft.public.excel.misc
Hubitron2000
 
Posts: n/a
Default Display result of formula in header?

I want my header to say "yyyy results", where yyyy is the current year.

Any suggestions?

  #2   Report Post  
Old March 24th 06, 08:01 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Display result of formula in header?

With the current year entered in A1,

Sub CellValueInHeader()
With ActiveSheet.PageSetup
.LeftHeader = Range("a1").Value & " Results"
End With
End Sub

Vaya con Dios,
Chuck, CABGx3



"Hubitron2000" wrote:

I want my header to say "yyyy results", where yyyy is the current year.

Any suggestions?

  #3   Report Post  
Old March 24th 06, 08:25 PM posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Display result of formula in header?

Here is a Workbook subroutine - in VBA Editor Project click ThisWorkbook;
and copy Sub there.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim dte As Date
dte = Date
With ActiveSheet.PageSetup
.LeftHeader = Format(dte, "yyyy") & " Results"
End With
End Sub

Found in Google Newsgroup search; acknowledgement to Bob Philips in
microsoft.public.excel.misc Fri, Nov 4 2005 1:01 pm

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Hubitron2000" wrote in message
...
I want my header to say "yyyy results", where yyyy is the current year.

Any suggestions?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency to Text mytipi Excel Worksheet Functions 1 February 22nd 06 12:43 AM
How do I display the RESULT of a formula Poor microsoft user New Users to Excel 3 April 27th 05 03:18 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 08:21 AM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017