View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] edwardzbrown@gmail.com is offline
external usenet poster
 
Posts: 1
Default placing a reference to a cell in a print header

What if I don't want the "Active"Sheet, I want the whole workbook to print with todays date. And instead of using a cell as my reference, I want to just use my own formula. Just the "=" sign shows. I want to insert a formula so I think my syntax has to change. What do I put to let it know to use the following formula?

="Printed: " & TEXT(TODAY(),"mmm dd, yyyy.")