Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A couple of questions (formating & Collating worksheets)
Morning all, So far I have managed to insert a new worksheet from a hidde 'template'; unhide it and through a UserForm, change the name of tha worksheet; in addition I have managed to place the name of th worksheet in a given cell (worksheets are indiviualised to staf members and I need their name to appear for a formula to work) - so fa so good! My problems are two fold; 1. I need the worksheet name to appear in the header when printing (th user's name) but no matter how I try I can't get it to work, here is m line of code: .CenterHeader = _ "&""Arial,Bold""&11Sheet name here!" & Chr(10) & "" & Chr(10) "&10POther text here" This obviously places 'Sheet name here' as the first line of the heade and I need the ActiveSheet.Name to appear! 2. I collate all remaing worksheets into one called 'Master' and have another worksheet hidden called "Template". Currently I use the following code to collate the remainin worksheets: 'loop thru an array of sheets For Each wsSrc In wb.Worksheets( _ Array("Carrie", "Dave", "Eileen", "Geraldine", "Jabeen", "Jackie" "Julie", "Pauline", "Rebecca")) 'alt: array(2,3,4,5) How do I add additional sheets to this when they are created i.e sa one called "Joe" Sorry for the long post but I only need to have these cracked for m project to work much better! (always enhancing :) ) Thank you, Dav -- deele ----------------------------------------------------------------------- deelee's Profile: http://www.excelforum.com/member.php...fo&userid=3486 View this thread: http://www.excelforum.com/showthread.php?threadid=55639 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
couple of questions | Excel Discussion (Misc queries) | |||
Couple of Questions | Excel Discussion (Misc queries) | |||
A couple of questions... | Excel Discussion (Misc queries) | |||
Couple more questions... | New Users to Excel | |||
A couple of questions | Excel Programming |