Ignoring formulas in Custom Headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display the path of the excel file in the header, but it changed
"&D" into a date.

How do I prevent Excel from doing this?
 
Thank you very much for the reply. I noticed that everything with a & before
it turned into a blank space. Browsing other header options, I borrowed code
I didn't know about: &[Path]&[File]

This doesn't allow me to show me the mapped network drive letter everyone
uses, so I will use your solution instead.

Thanks again.
 
you're welcome and thanks for the feedback

Mizuchi said:
Thank you very much for the reply. I noticed that everything with a &
before
it turned into a blank space. Browsing other header options, I borrowed
code
I didn't know about: &[Path]&[File]

This doesn't allow me to show me the mapped network drive letter everyone
uses, so I will use your solution instead.

Thanks again.

JulieD said:
Hi

use
&&D
instead

Cheers
JulieD
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use custom properties in an Excel header or formula? 5
Setting up Default Headers/Footers in Excel 3
How pull ID#s that meet specific "yes" requirements 3
Excel Header - Auto Format troubles 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
"&" in Custom Header 3
Hide or Protect Headers 2

Back
Top