Results 1 to 6 of 6

Combing text and cell contents in header

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-17-2005
    Location
    Wokingham
    MS-Off Ver
    365
    Posts
    111

    Combing text and cell contents in header

    Hi

    I wish to combine some text "Due date" and the contents of a cell in a left header, I've experimented and created the following but, the text is ignored. Everything else works okay.

    Sub TE_Add()
    '
    ' TE_Add Macro
    '
    'Add active sheet to each sheets's header
        Dim ws As Worksheet
        For Each ws In ActiveWorkbook.Worksheets
                ws.PageSetup.LeftHeader = "&26Due Date"
             ws.PageSetup.LeftHeader = "&26 " & ActiveSheet.Range("J3").Value
                 ws.PageSetup.CenterHeader = "&26New Order"
            ws.PageSetup.RightHeader = "&26 " & ActiveSheet.Range("D2").Value
    Next ws
    End Sub
    '

    Any ideas?
    Last edited by Steven811; 04-23-2010 at 08:20 AM. Reason: Resolved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1