Mon 14 Jun 2010, 09:43Delegate Natalie said...
Natalie has attended:
Excel VBA Intro Intermediate course
Linking headers to a cell value
Let's say that I have a workbook with 3 worksheets. On sheet 1 in cell A1, I have the name of the company. What code would I need to have the headers in each worksheet be equal to the value of cell a1 in worksheet1 followed by the name of the worksheet?
Thanks
Wed 16 Jun 2010, 13:48Trainer Stephen said...
RE: Linking headers to a cell value
Hi Natalie
Thanks for your question
This involves setting various properties of the pagesetup object. For example
With ActiveSheet.PageSetup
.LeftHeader = activesheet.Range("a1").value
end withSets the left header of the active sheet equal to the contents of range A1
Hope this helps
Regards
Stephen
