Ignoring formulas in Custom Headers

M

Mizuchi

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?
 
M

Mizuchi

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.
 
J

JulieD

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...
 
Top