Dear Sir,
I need to speed fill 1 to 5 in column B repeatedly as illustrated:
    A    B    C
1        1    xxxxx

I have some source HTML code that I need to put in a single cell in Excel
2003 for testing purposes.
I've tried pasting special with all options, no luck. I saved the code
snippet to a .txt file first (to strip formatting) and it still wants to

Dear Excel-lencies!
I wonder whether somebody has already created a complete list of new
(or changed) shortcuts in Excel 2007?
Anyway, here is *my* list of new (or changed) shortcuts in XL2007:

If I drag data to another cell, it takes away the formatting in the old cell.
For example, say I have a cell formatted to show negative numbers in
parenthesis (eg: -4 = (4.00)) and I drag that to another cell, if I enter new
data in the original cell I dragged from, the ...

I was using the formula below:
=SUMPRODUCT(--(N1:N100<TODAY()),--(BM1:BM100="yes"))
and it doesnt actually only return the number of rows which have both a date
in the past in col N  AND  have a value of "yes" in col BM.

I've got One column of data that has...
FirstName
LastName
City

Could someone please help?  I'm having trouble creating a named range,
and adding that range to a ComboBox.  The range that I want to add is
horizontal, cells A1:E1, calling it "Test".  When I add "Test" to
ComboBox by doing ComboBox1.ListFillRange = "Test", it only shows A1

I have a column of random numbers.  Is there a way of counting the numbers
that appear the same, given number of times in the column in a formula?  For
instance, if numbers a, b and c appear x times, then the answer would be 3.
Thanks in advance.

I am working on a sheet for an employer who wants to be able to run a macro
and find duplicate entries and in put the correct price based on the search
criteria.
He wants only one sheet and the sheet must be dynamic as updates will be

What is the vba equivalent to the worksheet proper
function?

When I use autosum function some cells fill with a row of hash symbols
although correct sum is visible on toolbar at top. How do I stop this?

using Outlook 2007
how do I set my inbox to display messages received for the past 14 days.  
And by the way, where did all these messages go?  I checked my archive folder
and it is only saving my sent messages.  Thanksd in advanced.

Hi,
I'm working w/about 100 tabs that contain data.  I have a macro that will
copy and paste the data and have tested it on three tabs (recorded macro).  I
also have a macro to delete empty rows between data.  I could continue to

Ok guys and gals this is what I have. I need to put () around whole numbers
and negative numbers need to read out normal. Here is an example.
12 would read out as (12)
-12 Would read out as 12

I have two stores.  I have a spreadsheet generated by company software that
shows inventory at both stores, but on separate lines.  For example:
Store      Item      Qty     Qty Store 2
 1            A         4        ?