View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mvyvoda mvyvoda is offline
external usenet poster
 
Posts: 41
Default 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")

..CenterHeader = "&""Garamond,Regular""&36Account List"

For example, depending on when 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 a lot. You guys are always very helpful!!!,
-m