Copy Cell Value (text) to Header?

's Computer Specifications

I want to grab the text in a cell (company's name) and automatically copy it
to the header using a macro.

Thanks for any help.
Mike

's Computer Specifications

Mike,

Try something like

ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Range("A1").Text

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (E-Mail Removed)

"theFrog" <(E-Mail Removed)> wrote in message
news:3uyrb.8918$(E-Mail Removed)...
> I want to grab the text in a cell (company's name) and automatically copy
it
> to the header using a macro.
>
> Thanks for any help.
> Mike
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: How to copy a cell and horizontally expand the paste along header	Gord Dibben	Microsoft Excel Misc	1	10th Feb 2009 03:43 PM
RE: How to copy a cell and horizontally expand the paste along header	Khoshravan	Microsoft Excel Misc	3	7th Feb 2009 06:18 PM
Automatically copy form-field text to text box in header of same d	=?Utf-8?B?TWVyY2VkZXMuSw==?=	Microsoft Word Document Management	7	30th Sep 2007 02:37 PM
using text from a cell in the header	=?Utf-8?B?RW1pZWw=?=	Microsoft Excel Misc	1	1st Mar 2004 04:19 PM
using text from a cell in header	=?Utf-8?B?RW1pZWw=?=	Microsoft Excel Programming	2	1st Mar 2004 04:15 PM