At present I am using the following formula to count the number of
date entries in a column,
=COUNT($AL$1000:$AL$5000,"<=today()")
I would like to know how to modify it so that it counts the number of

I want to write more than 29 array varibles (defined in a my VBA code)
in a workbook range. Is there a way to accomplish this?
Here is my sample code (check my remark):
Sub ArrayTest()

I am writing a macro in excel to copy data from a cell and put it in
a
new word document. I have managed this OK, but i am struggling to
find

I noticed a change in behavior in Excel 2007.
I am using Data Table to create a list of values and then have a formula
computing the mean of these values.
When the results of Data Table change, the average is NOT updated.

Switched to Microsofts version of Excel for Mac.  Can anyone tell me
what keystroke allows me to edit a cell?  Before I switched to a Mac
it was the F2 button.  Please help.  Thank you.

WinXP, Excel 2007
I am unable to show this number in a cell. How do I do it?
Thank you.

I have a worksheet with 3 columns (A, B & C) of numbers.  Somehow, I
need column "D" to get the first zero in column "A" to match up with
the first number that appears in column "C", the second zero in column
"A" to match up with the second number that appears in column "C", the

Is there a way to insert a date and time in a cell(s) that will only be updated
if there is a change to the worksheet. I'm looking to have the date/time of the
last update so that it is easy to tell how current the worksheet is.
Thanks

I'm working on an Excel 2003 application and I would like to completely have
a way to hide all menus and status bar from Excel 2003. Essentially I want
it to appear as if this is a Win32 application. Any ideas? Also, how can I
turn them back on when I want to work back with ...

I have a drop down list - well many actually that are working fine....
except that the values in the drop-down list are literally too amall
to read (at least for me!!!).  
The choice selected will display correctly ( font size etc. ) in the

Whenever I change the colours in a pivot chart and then add/amend/refresh
the pivot data the colours revert back to the original defaults.
Is there any way to prevent this so I can retain my selected colours?
Many thanks,

I have 100 row, single column list of text strings.  I am wanting to
concatenate all these together, but with " Or Like " between each string.
This is to enable me to prepare a long criteria expression for Access
without all the re-typing.

How do I get a macro to stop for input from the user ? I want the user to be
able to click on a button, to print a soreadsheet to a pdf file (using
PDF995). The macro must stop for the user to enter the file name, and then
continue.

I am having a very diffcult time  trying to get per centages of columns
on a xl  spreadsheet???

My table has 3 columns: A, B, and C.  C has all numeric values.
I want to SUM values in C for all rows where value in A equals "a" and value
in B equals "b".
Can anyone tell me a formula construct for this?