I have a number of working papers that all have a 3 line header. The first
line is the company name, 2nd line is the GL account name and number, the 3rd
line is the "As at" date (January 31, 2007, Februay 28, 2007, etc.) It
changes every month. I thought I could record a macro to update the date
each month but it replaces the entire header. Is there a way to do this??

The easiest way would be to have your macro create the entire header.

Is there any reason the macro can't come up with the company name and GL account
name, as well as the as at date?

--
Regards,
Fred


"jostlund" wrote in message
...
I have a number of working papers that all have a 3 line header. The first
line is the company name, 2nd line is the GL account name and number, the 3rd
line is the "As at" date (January 31, 2007, Februay 28, 2007, etc.) It
changes every month. I thought I could record a macro to update the date
each month but it replaces the entire header. Is there a way to do this??

I have approx. 50 working papers per month for 5 different companies so would
require too many macros and wouldn't be any easier than changing the headers
manually each month.

"Fred Smith" wrote:

The easiest way would be to have your macro create the entire header.

Is there any reason the macro can't come up with the company name and GL account
name, as well as the as at date?

--
Regards,
Fred


"jostlund" wrote in message
...
I have a number of working papers that all have a 3 line header. The first
line is the company name, 2nd line is the GL account name and number, the 3rd
line is the "As at" date (January 31, 2007, Februay 28, 2007, etc.) It
changes every month. I thought I could record a macro to update the date
each month but it replaces the entire header. Is there a way to do this??