Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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")

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a simple answer? Jim May Excel Discussion (Misc queries) 2 December 20th 07 07:14 PM
Dynamic Headers via VBA - Probably Simple Answer????? mvyvoda Excel Programming 0 June 13th 06 06:03 PM
There may be a simple answer ... Lee Bowman Excel Discussion (Misc queries) 2 November 8th 05 03:41 PM
row location....hopefully simple answer :-) cadcamguy Excel Programming 6 June 26th 05 01:14 PM
simple question, hopefully a simple answer! Matt B Excel Programming 5 January 13th 04 08:43 PM


All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"