Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Headers via VBA - Probably Simple Answer?????
How would I print a Header via VBA that would change based on the following
array?: OSRList = Array("BS", "CK", "HS", "IT", "JD", "JW", "KC", "KF", "MG", "MM", "SM", "TS", "VD") The code I am using looks like this: ..CenterHeader = "&""Garamond,Regular""&36Account List" Currently it only prints "Account List" on the page. I need it to print dynamically. For example, depending on whom I want to print, the header's would be "BS Account List," or "KF Account List," etc.? Even better, how can I replace "BS" with "Brian Sommers" or "KF" to "Kevin Franklin?" I would need a reference array... Not sure where to go from there. Thanks for your time and energy, -m |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a simple answer? | Excel Discussion (Misc queries) | |||
Dynamic Headers via VBA - Probably Simple Answer????? | Excel Programming | |||
There may be a simple answer ... | Excel Discussion (Misc queries) | |||
row location....hopefully simple answer :-) | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |