Header Date Range

[GreatLakesJK]

I have several worksheets that all have similar headers. In the header, on the left margin is the title of the worksheet, which is a static value. On the right margin I have a date range, which needs to be changed weekly.

I understand Excel has the feature where you can include "&[Date]" and it will auto-update based on the current date, however I'm looking for a range. To be more specific, the report will be updated every Monday morning, and will pull in the last week's data (Sunday to Sunday).

Ideally the format would be mm/dd/yyyy - mm/dd/yyyy.

Any thoughts on how I can auto-magically make this happen? Thanks.

[alansidman]

You can set the header/footer to reference the value of a cell that contains
your formula. For example:

Please Login or Register  to view this content.

[GreatLakesJK]

Argh! I have been fooling around with your suggestion for the past 30 minutes and can't get it to operate. I really wish I knew VBA better.

I was hoping you might be able to show me the application in a sample workbook. I am attaching a sample for you to execute the code. If you could please update as you mentioned, then maybe I could see exactly how you do it.

Sorry for being a noob on VBA, but this is driving me crazy.

[martindwilson]

testing

Please Login or Register  to view this content.

[GreatLakesJK]

So I shared this problem with a friend, and he suggested I under a different code snippet. However it seems much more complicated. Any suggestions?

The reference cell is in Trigger! B2.

Please Login or Register  to view this content.