How can I fix 'Runtime error 1004 - Unable to set the center footer property of the page setup class' I would like a reference to a cell in the footer.
Code:
Sub UpdateFooter()
ActiveSheet.PageSetup.CenterFooter = Range("A1").Value
End Sub
I have changed (in Page Setup) the orientation of my document from Portrait
to Landscape but Page Break Preview and the document itself does not show the
landscape format. When I print a page, the page setup changes show.
How do I see the document in landscape format so I can set column widths,
etc.?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...lic.excel.misc
This might seem a strange type of Excel question.
Some "Clever" person decided to create a site plan using MS Excel. It has been done quite well tbh. The problem with Excel is that I am unable to set a custom page size as this plan sits nicely on a paper size I made ealier through using Word. Guess what there is a custom page size selection on Word but not Excel. Is there a walkaround for this ?
The only other way I can do this, is to print off 2 a4 landcape print out but the printer goes to the next page and leaves a nasty seperation.
The copy of Excel i have is 2003 sp3
I want to create a set of charts to easily compare a range of values across criteria that I can easily (and automatically) change to see the data in different ways.
I have data like this:
Sheet1
A
B
C
11
CategoryAlpha
CategoryBeta
Results
12
A
4
13
C
3
Boko
14
D
4
Deko
15
E
2
16
A
1
Deko
17
D
1
Boko
18
B
3
Deko
19
D
1
20
A
1
21
E
4
22
C
4
23
B
2
Deko
24
B
2
Boko
25
B
2
Boko
26
C
3
27
E
2
Deko
28
C
4
Excel tables to the web >> Excel Jeanie HTML 4
I summarize it like this:
Sheet1
A
B
C
D
E
F
G
H
I
1
A
A
B
B
C
C
D
D
2
Deko
Boko
Deko
Boko
Deko
Boko
Deko
Boko
3
1
26.3%
15.8%
38.1%
38.1%
25.0%
36.1%
17.9%
39.3%
4
2
33.3%
38.9%
19.0%
42.9%
32.0%
28.0%
23.8%
38.1%
5
3
14.3%
42.9%
44.0%
28.0%
29.2%
37.5%
28.6%
46.4%
6
4
24.1%
37.9%
35.9%
35.9%
21.7%
39.1%
39.1%
30.4%
Spreadsheet Formulas
Cell
Formula
B3
=SUMPRODUCT((CategoryAlpha=B$1)*(CategoryBeta=$A3)*(Results=B$2))/SUMPRODUCT((CategoryAlpha=B$1)*(CategoryBeta=$A3))
Names in Formulas
Cell
Name
Applies to
B3
CategoryAlpha
=Sheet1!$A$12:$A$504
B3
CategoryBeta
=Sheet1!$B$12:$B$504
B3
Results
=Sheet1!$C$12:$C$504
Excel tables to the web >> Excel Jeanie HTML 4
I want to create small bar charts (16 of them) for each data pair.
I created a defined name that will properly give me the pair of data (using OFFSET) when put into A1:D4 in a new sheet:
=OFFSET(INDIRECT("Sheet1!"&CHAR(64+COLUMN())&ROW()&":"&CHAR(65+COLUMN())&ROW()),2,COLUMN(),1,2)
When I use that with SUM() or CELL("address",) or whatnot, it works right.
But when I try to put it into the SERIES() function of my bar chart, it gives me the following error:
"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are correct, and try again."
The SERIES() formula is the (very simple):
=SERIES(,,Sheet1!$B$3:$C$3,1)
It gives me the error when I try to change it to:
=SERIES(,,SeriesSource,1)
(SeriesSource is the Name of the above OFFSET formula).
What am I doing wrong?
Or rather, even if I could do it right, is there a better way?
How do you set up the size of the page (ie paper and margins) in excel 2007
If its not moving i can't see it !
I want to add a reference to a cell value in the header of an excel 4 page.setup macro. I've been trying to re-work a macro that John Green posted.
I've been trying variations on:
Dim head
Dim psetup
Dim sProductivityWeek As String
sProductivityWeek = cStr(Range("WeekOf"))
head = """&LPRODUCTIVITY WEEK OF """ & sProductivityWeek
psetup = "PAGE.SETUP(" & head & ", etc.
Application.ExecuteExcel4Macro psetup
Thanks
Richard
Have a excel document with multiple tabs that was created by an end user and
when the user prints the entire document to an HP Laserjet 4 printer it
prints fine.
When the end user sends the excel document to her manager and he prints the
document, the printer is asking him to load a A9 paper. It will not print
the spreadsheet until you load that paper.
The end user that created the document sends the document to severl other
people that have various printers. Some of them can print the document fine
while others can not.
Trying to figure out, why the document can print on some printers while
others it is asking your to insert a differnt page size other than letter.
Any help you can give me would be greatly appreciated.
Hello.
I am trying to adjust the margins and orientation on an Excel 2007 file, but for some reason I cannot adjust Margins or Orientation - they're greyed-out.
How can I fix this?
See Screenshot below:
http://i150.photobucket.com/albums/s...dpicture-4.png
Hello,
I have one Excel file that has been in use for quite a while. Now, everytime I go to the page preview and push the SETUP button, the whole workbook closes.
Upon re-opening the file, the document recovery is on the left hand side. So it seems Excel realized that there was a problem, even though no error message was ever displayed.
Does anyone have any ideas?
Thanks a lot,
Kai
Changing the scaling to a percentage does not change the page; but rather the
zoom factor of the windows display! (I am trying to print an 11"x17"
worksheet on a 22"x34" page, which works on our other workstations) This only
seems to be on my computer, and I've added SP2 and updates to make sure that
I have the latest of everything. I've looked through Options to try and find
a setting that may be causing this, but am having no luck. Thanks!
