Page Header

  • Thread starter Thread starter jake1729
  • Start date Start date
J

jake1729

Is there a way to refer to a specific cell from the page header WITHOUT
using VBA? Thank you!
 
No.

What's wrong WITH using VBA?

Just in case you change your mind...........

Sub CellInHeader()
With ActiveSheet
.PageSetup.CenterHeader = .Range("A1").text
End With
End Sub


Gord Dibben Excel MVP
 
Gord,
I have an Excel file that is very simple. I want any user to be able
to open the Excel file without any warnings. The type of people
receiving the Excel file are computer literate just enough to open
Excel and type in some data.

On a side note, why do you think this is not available? Or why will
the shortcut "Ctrl-E" not center text in a cell. I am a computer
science student so such 'errors' interest me. Thanks!
 
You must log in or register to reply here.

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 could I display an excel cell contents in a page header ? 1
Access Sorting and grouping using multiple tables 0
Access Page Header with merge field 0
Omit header from first page without embedding header in code 6
adding page numbers 1
Header or Footer - Reference a Cell 5
PUT PAGE NUMBER INTO A SPECIFIC CEL? 1

Back
Top