How do I define an array constant as a name?
I tried to insert a name as follows
Name: 2006!AgeRange
Refers to: ={<16,17-18,19-49,>49}

I want to push a control 'button' and change
cell A2   from "y" to "yy" , i.e. add the letter 'y' for each push.

I need a realtime time (seconds ) function in a cell.
second(now()) is not a realtime function. I need to push F9 to have the real
time calculated.
Do I need vba for this and how?

I have a sheet that looks like this with phone #s filled in
                       a          b          c       d           e
                    home   home2   car   office   office2
1  Tom

I have a situation that I hope someone can give me a good answer to.  Please
bear with me as I try to explain my needs.
My goal is to have an Excel spreadsheet that pulls from a SQL database and
the the query pulls from a variable in the Excel sheet.  For example let's

I receive a test report in Excel form. Each report is a workbook
consisting of several worksheets. All worksheets are identical excep
the data.
What I want to do is to set default view on one worksheet and apply i

Hi
I would like to know if there is a way to sort two different culumn
side by side. my problem is that in column one there is 8700 record
and the second has 3700 records,

I have recently upgraded to Excel 2003 and wondered why some of my
macros are not working.  I then discovered that where the macro moves
to another worksheet, it automatically runs the worksheet macro.   So
if the worksheet macro says Goto R1C1 but the macro which is running

(Running Office 2003 on XP Pro workstations, SBS 2003 server, Active
Directory domain).
I've noticed that if you tell Excel to print multiple copies of a workbook,
it sends the same document to the printer multiple times - i.e., for 3

I would like to add something visual on a spreadsheet (which is an
order form) so after my customers have filled it out they can SIMPLY
click a "button" and it will automatically send to my email address the
completed spreadsheet as an attachment, IS this possible?

I don't know if I am using the correct terminology but this is what
want to do:  I have placed formulas in multiple columns that calculat
my sales numbers for a bid.  The problem I am running into is that
change the bids for every person and when I clear a cell is clears th

I'm just adding the finishing touches to a spreadsheet and a large area of
one of the worksheets has been protected. However the spreadsheet is designed
with the functionality of autofilter in mind. When I protect the sheet it no
longer gives the ability to auto filter. Is this ...

I want o add up Time codes that are for 24  hours
The time codes are of the form
00001506
which means 15 seconds and 06 hundredths of a second.

Has anyone heard whether Office 12 will support DAO or not?

Is there an is like lookup function?
I am trying to look in column A for any items that have an HM, where column a
contains 1234HM, 12572, 24751BP, etc. and return in column B "yes" if there
is an HM....