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 |
All times are GMT +1. The time now is 04:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com