Thread: Text from within a sheet into right header
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Text from within a sheet into right header
Activesheet.PageSetup.RightHeader = Activesheet.Range("C10").Text

--
Regards,
Tom Ogilvy


"Darin Kramer" wrote:


Howdie,

How do I put text from say cell c10 into the right header by using
VB...?

Thanks

D


*** Sent via Developersdex http://www.developersdex.com ***

Reply With QuoteReply With Quote