Dynamic Header
I got it to work! Thanks!
"Shane Devenshire" wrote:
Hi,
Add this one line to a BeforePrint macro
ActiveSheet.PageSetup.LeftHeader = [V4]
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"JAbels001" wrote:
Hi! I have a worksheet where I need the Header to change based on a cell
value(V4)... Is this possible? I have worked through several VBA's but they
dont seem to do the trick. Thanks for any help!
|