Linking headers to a cell value

Resolved · Low Priority · Version 2007

Mon 14 Jun 2010, 09:43 Delegate 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:48 Trainer 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 with

Sets 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips