how do I enable macros in excell 2000

I am responsible for numerous tickets purchased by friends.  The effort is
to create a sheet where I will put in their numbers, and then when the
lottery is drawn, put in the winning numbers and instantly see how many
match.  For instance, if the first number on the winning row ...

The code doTEST_XLS below creates a command button.  Once the button
is created, in VBA, how do I create the sub or function I want to
run?  For example, if I want to create this MsgBox, what must I add to
my  doTEST_XLS code?

I have a worksheet in which I have a following array formula entered
in Q1:Q1000
={IF(MAX(IF($B$1:$B$1000=B2;$P$2:$P$1000))<30;0;1)}
I would like to write a macro that would enter such formula into

I need help with a formula for Cell E3 that will give me the total days
between cell C3 and D3 - Here's what I am trying to do.
Column C3 - Enter Deployment Start Date
Column D3 - Enter Deployment Return Date

This is my formula =COUNTIF(E11:E18;">0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do.  thanks
in advance for your help

Is there an easier way to concatenate a list of cells than by the
actual concatenate function? I've got a set of cells in column 1 (A)
below cell A3 that I want all concatenated together. Can I somehow do
this without adding each specific cell to a function? Like some kind

I am using the "find" function to locate a particular letter in a cell.
This works fine except when the letter does not exist in the cell.
Displayed in the cell is "#VALUE!" and is not useable.
Is there a way to

I am using Excel 2007 on Win XP Pro SP2,
How is it possible to do the following please?
I have several columns formatted to currency. When the amounts in them are
nil, they show up as follows: £0.00, I would rather they showed as an empty

I posted this under the links discussion group, but thought I might
try a bigger audience as I've yet to get a response
I have an .xls (2003) file that has a list defined in it.   I want to
paste a link from another .xls file (also 2003) into a cell within

Alright, fir one of my current projects, I need to output the contents
of the cell with the most text in it from a column. How would I do
this? I've tried arrays based on LEN, but I get the number of
characters instead of the cell contents.

Am I missing something here?  I would expect Excel 2007 to be easier to work
with than Excel 2003, but I'm finding the opposite to be true (with regard
to cell comments).
In 2003, I could format the comments the very same way I format the cell -

I am looking to add company names as a header but even with columns.
Any idea how I might be able to do this

Hi there I am trying to create a workbook that can monitor the progress of
students' results.
As of now I have managed to create worksheets using the "list" function.
Each worksheet is a list of the stundents in my class, a few other fields and

Is there a way to list the values in a block of cells.
     400 600 800
     350 200 625
     250 222 125