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