| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers and Macros
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing headers without macros or VB | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| headers | Excel Worksheet Functions | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Threaded Mode
