Is there a way to turn AutoScale *off* as the default on X and Y axis when
creating charts in Excel 2003?
Thanks,
Jeni

=IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)), "",Column A in
tableB)
This is the code i have.
I want to search tru all column B in table A. If i find an identical

I'm printing a sheet that has a key in it linked to anoher page with an if
statement.
all that shows up is a zero or one depending on the condition, etc.
Is there a way for format the cell so that it doesn't print when the

I'm trying to set up a continuous feed printing system using an Okidata 9
pin printer on an XP system with Excel 2003.
The paper is an odd size.  Between the tractor pins it is 9 inches, between
vert perfs its 8 3/8 inches.  But its only 4 and a quarter inches between

Hi everyone, I have been reading a lot and there is so much informatio
here--I am so glad I found this forum!
Now I am trying to find out if there is a way to make a report in Exce
for what I need.  Here are the details:

I need to make a macro which look up  a  column of an excel paper and
find the numbers that     once summed give the number in cell b5 for
example!!they could be 2 or 3 ..or 4..and so on!!

I'm trying to set up a column which already has text in it to
automatically format the text to have a capital letter when I type more
items in empty cells,  I cannot get this to go, any help
Thanks

I would like to change a cell's background colour if a certain value is
entered in another cell. For e.g., if Yes is entered in cell a5 i would like
to have cell c9 in green. I would be grateful if you could provide me a
formula that could do this for me.

I am new to VBA so just finding my feet, can anyone help me with th
differences between an excel control (i.e. one from the form toolbox
lets say a checkBox and a vba checkBox?
From trying the two controls the I have noticed is that you canno

When I write a formula, that is truly long, I recieve a message "Formul
is too long". Is there a way to remove this limitation so that I coul
write long formulas?
Any help is welcome.

Hoi,
Does anybody know how to make a loop in this example?
This is a snapshot of my code. I want a loop from 2002 to 2006, see the
letter i in my code, but this doesn't work. Does anyone have a clue?

I have a file that's about 50 000 rows long, and 4 collumns wide. An
this whould work just fine, but I would not like to print a little ove
700 pages... So now I've tried to change the sheet so that I could get
collumns on every page (insted of 4). So that I could get two of the ol

I have  small company and use excel for invoicing and save each worsheet from
a tempate as a new invoice (unique number). I was wondering is the a function
i can use to calculate all the running totals? All the total and tax etc are
in the same cell s but on different sheets. can ...

is it possible to access this newsgroup through a newsreader..if yes
what are the settings??I can access the italian excel newsgroup but not
this one!

Is there a formula that will let you insert a blank row or skip n rows?
I know it can be done in VBA but i suck at vba so i dont want to go
down that path.