98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Linking headers to a cell value
Linking headers to a cell value
Resolved · Low Priority · Version 2007
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
Wed 23 Jun 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |
