insert named cell in header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I have a workbook with multiple sheets using the same header. I'm trying
to insert the contents of a named cell from the first worksheet into the
header that is used for all of the other worksheets. The first sheet is
called Data Entry. The named cell is Target. The header would look like this:
Company name: <Target>

Your help would be greatly appreciated!
 
Sub Name_All_Sheets()
Set wkbktodo = ActiveWorkbook
For Each ws In wkbktodo.Worksheets
ws.PageSetup.RightFooter = "Company Name: " & Range("Target").Value
Next
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to hide password? 1
Sheet name=Cell value 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Find Specific Rows in Range and Create New Tab 18
Post my named ranges in column A 10
Change sheet names based on cell contents 6
Macro to complete Google search based on a cell? 0

Back
Top