I work in sales analysis and use files that have many many pages with
lots of information and formulas. Is there a method either in VB or in
data validation for me to check that I have done a petty but
meaningful task that I may have missed? For example, if I am ranking

do you know ?
How many cells can man call under the same name in a worksheet?
Can we expand the limit with vba ?
How many "named range" (plage de cellules fusionnées auxquelles j'ai donné

I'm using data validation with dependent dropdowns (thank you Debra
Dalgleidh) where if I choose from a dropdown in one cell, the choices
available in the adjacent cell's dropdown automatically limit based on the
first cell's value.

How can i get excel 2007 to show open workbooks seperately on the windows
desktop? I want to look at two workbooks at the same time, but unlike Word,
Excel doesn't do that.
Thanks,

Suddenly I'm getting the following error when I try to double-click on an
Excel spreadsheet to open it:
Windows cannot find 'xxxx'.  Make sure you typed the name correctly, and
then try again.

I have a sheet that I want to change daily. Each day has a colour to a cell
for that day.
The day is obtained by =NOW() function reporting the day only.
I want to background colour the cell the day is reported in differently each

Is there a simple way to extend conditional formatting to cover more than 3
conditions?
thanks

I have a sheet set up with a pivot table that is ready to print, except the
auto-positioning of page breaks sometimes breaks up related items.  Main row
fields are in column A, and sub-related items are directly underneath that
and indented in column B (like an outline view).  ...

How can I change the font size on a label in a form. There is no
obvious option (in 97').
I have tried font.size = 12 etc to no avail...
Cheers....

Okay, I want you to know I usually try to do my best in terms of searching
for solutions and experimenting before posting, but this one is eluding all
my attempts.
Using Excel 2000, but same thing happens in 2003:

An XLS file (workbook) of mine contained a macro that I never used,
and I was annoyed that whenever I opened it I was warned:
 [filename] contains macros.  Macros may contain viruses.
 It is always safe to disable macros, but if the macros are

I received a spreadsheet from a client with hundreds of rows of dollar
amounts.  The cell that have a figure that is 1.00 or greater have no
problems, but the cells that have a dollar amount from 0.01 to 0.99 show up
in the cell as ="0.25" instead of 0.25.  This is obviously ...

I was wondering...when I try to change my settings in my Excel program I get
a message telling me "Cannot Access Directory?"
Is there something I can do to get rid of this?
thanks

Hello, hope someone can help.
I have a list of records in Excel which are attributed to teams in my
organisation. Say its a list of staff. What I need is to be able to send the
file out so that a user can select from a drop down menu the team name and

I currently face an (apparently) odd issue. Googling was of no help.
I do have an order form template. When I create a new Excel workbook based
on this template, I would need to retrieve (with VBA) the filename of the
template. I wonder if there is any built-in function allowing ...