why does Excel see my simple formulae as macros now?  Cells will not
automatically recalculate when that function is enabled.  virus
scan/spyware/firewall all up to date and active.  I don't use macros, so how
did Excel convert simple "divide this cell by that cell" into macros ...

I use this formula:
=SUMPRODUCT(--(D3:D5="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5))
I would like to add the condition: If D3:D5="OrderO" and E3:E5="BOX017" and
F3:F5="Directed" and G3:G5=226. Not sure how to do this - do I need to use an

I work at a bank and am responsible for updating possible loans.  Each
officer enters his/her personal loan info into a seperate WS, the totals of
each officer are then rolled into a summary WS.  Is there a way so that the
summary WS updates as the individual officers change ...

Hi People,
Is there a way (function) to display the name of the file, from whic
you have imported data into your sheet, in a cell of that sheet.
The data is imported using Data - Import External Data - .....

I have an existing spreadsheet that is used for different types of loan
accounts. Each of the different loan types are assigned a number designating
the type of loan it is. For examlpe; a residential loan may be a "type 3" and
a commercial loan a "type 5". The types can also be ...

Calcutating the following
=H70*I70*N70
returns
211.20

Calcutating the following
=H70*I70*N70
returns
211.20

So, I want Cell A1 to equal the value in lbl1.Caption. I tried:
Code:
--------------------
   =lbl1.Caption

How can I create a macro "button" over a series of columns that will cause a
formula in another part of the sheet to ignore the value that the column
calculates to?
i.e.

Is there a way to get a list of the names, that one has defined in
worksheet, whilst entering a formula into a cell or a graph?
If not is it something other people would find useful
--

I have an excel sheet with the month and year in the A row..Like
Jan-06 Feb-06 Mar-06 Apr-06
How do i insert a formula in B row, to display the number of weekdays
in that corresponding month, like this?

I have a range (a1:a5) with values such as:
0, 5, 25, 0, 3
I want to pick the smallest value other than zero because I will use that
number to divide by and do not want the #DIV/0! error. However, the initial

I would like to combine the contents of multiple columns into one column as
shown below:
apples     oranges      peas
pears       lemons      carrots

if i combined lists A and B of names into one list, how do I seperate them
again? Is there a way to filter out list A, leaving only list B remaining?

I understand that a full path is not necessary for a reference, but for
discussion and illustration, say it does...
In AJ5 =LEFT(CELL("Filename",A1),FIND("-",CELL("filename",A1))+1)
and evalutes to c:\Mypath\Myfile - (with spaces before and after -)