A cell ion a spread sheet has (mysteriously) acquired a reaction which as
far as I can see is "Oick From List"
e.g when I enter a it provides the entry Annual>
                        o                               Owner

I have a 365 row sheet for each day of the year....I would like Excel to add
2 blank rows below every cell that has "Sunday" in  it.
dates are entered as 1/1/2007  but are displayed using a custom display of
ddddmmmmd

Is it possible to make a template for the Send To Mail Receipant as
Attachment in Excel 2003 so that the e-mail addresses, subject and body will
already be filled out and then just have Excel attach the spreadsheet?
Thanks

Does anyone know if I can use the sumproduct() formula in parallel columns?
For example lets say that I have n columns A1:A100 =1:100,
B1:B100=10:1000,C1:C100=101:200,D1:D100=1010:2000,…,etc.
I would like to calculate the sum A*B + C*D + …..+ Xn*Xn+1, using

I have an extensive data table sorted by payee. Each payee has many
records. I would like to insert a blank row after each change of payee.
Yes, I could do it manually but the table is very large. Is there an
easier way to do this?

I am trying to use the Get External Data function to pull data from an Access
query however I keep getting an error that says:
"Microsoft Query: msqry32.exe - Application error
The instruction at 0x000000072 referenced memory at 0x000000072. Memory

Hi ,when I copy a spread sheet in exel & paste it to a email the rows & cells
are gone & the number are not under the original columns so I have to move
them back ,when I send the email the numbers move back ?how can achieve a
exact copy to email.I can do it to word  then I try ...

I have a user form which has been set up to be used as a menu with lots
of buttons doing various operations.
After clicking a button and carrying out the task(s) I would like to
able to move back into a worksheet(s) do some work and then step back

I need to create an excel spreadsheet but not sure how to achieve it. (this
is for commission payout)
On sheet 1 starting lefthand side is "name" next column would be "client"
next "PB" next "Paid Date" then "Outstanding"

Is there a function that will give you the sheet name in a cell? (Example:
A1)
I would like to write an IF statement that will refer to Sheet Names.
Thanks

Hi Dave,
First of all, a great thanks to you for helping me numerous times in
making my project a successful one.
I am about to wrap it already. Just one final favour, this is something

When starting Excel 2003, an error message box appears.  "Microsoft Visual
Basic" appears in the dark blue header of the dialog box.  The message
inside the box is "Compile Errors in hidden module <module name>"  where the
module name is different every time we start Excel.  ...

I have a worksheet with 10 columns and 1 to 100 rows depending on the
number of clients we have in a day. I would like to write a macro that
automatically figures out the print size necessary and prints the sheet
or sheets necessary to print all the information. For example ...

In Excel, I need a macro that will delete an entire row based on a name
entered into an input box that would match a worksheet with that name
in column "A".
Thanks,

i have a date format like this - 13.02.2007(dd.mm.yyyy)
i like to convert it to date so that i can sort it by date.
i already used the format cells to change the category type to date but
nothings happen.