The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Linking headers to a cell value

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Linking headers to a cell value

Resolved · Low Priority · Version 2007

ReplyMon 14 Jun 2010, 09:43Delegate Natalie said...

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

For upcoming training course dates see: Pricing & availability

ReplyWed 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 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.

Access articles

· How To Import Data Easily Into Access 2010
· An Introduction To Queries In Access
· Find Out About The Join Property In An Access Query
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· User-Proofing Your Access Database: Part 1

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

How To Change The Case Of Letters In Word

Speaking as someone whose typing skills do not allow him to watch the screen as he types, I have often come across that annoyance of accidentally typing with the Caps Lock on. It used to be a case of deleting and re-typing the whole passage until I came across this very useful trick.

» Article: Word training courses in city of london

I need a macro the change the column selected with a cell reference. For example C3 to E3, Without changing the row.

For some reason macro's will not record when I press the arrow keys.
Thanks,
Mekanto