I have a macro that I need to save to the network drive (R). The only
problem is that the macro below when U run it save the files to the documents
folder. I have no ideas why this is happening. If anyone has any ideas as to
why this is happening I would be VERY grateful for the ...

I posted a question on this board last week and BJ gave me a date formula
that helped me out with a problem I was having.  I need to know how to alter
the formula for a different scenario.
BJ gave me the formula: =DATE(YEAR(A1),CEILING(MONTH(A1),3)+1,1)

I have an issue about get the largest number(and top 5, top 10) from
the column I have. I used to combine large function and max fuction to
grab the total number back. Here is my old fornula,
=large(A1:A200,1)   will give me the largest number

I am using the following formula for an average function, but it doesn't
quite do what I need it to do.
=AVERAGE(IF(F3:F38<>0,F3:F37))
There are cells in this that I need to omit from the average, because they

I have in column E mix address with post codes
eg: Blythswood square
G12BG Glasgow
In the text the split between address and post code is by Enter

I have a grid  which has letters across the top.
I also have numbers down the left side.
In some cases I have an "X" in the intersection of the numbers &
letters & in some cases I don't.

I want to use a formula to count the number of cells in a range that are
highlighted a certain color. Is this possible?

Hi
I have the following formula in one of the cell
=COUNT(IF((TRIM($C$4:$C$96)="P")*ISBLANK($M$4:$M$96),$A$4:$A$96))
But I have autofilter command and I want the rows to be counted based on the

I trying to change -3210 to (3120) but can't find how to do it.  Can anyone
help me?  I'm using the 2003 version.  Thanks

I have a number of values ranging from positive to negative that I need to
sort into 5 categories depending on different ranges (i.e the number 3 and 5
are "1-10" and so on)
ex. of values:

I am trying to do a look up of sorts onto a large table of mortality rates
and essentially want to transpose what I have in one table so I get the
following in another (example given based on a 4x4 square):
A4  A3  A2  A1

Is there a function to count the cells in a range, which have a given
interior color?

Used to work with Excel 2003 and went in option and changed the setting there
- how to this in 2007 excel

Please, could any one help me to save the result resent in a cell following a
calculation (by functions), despite changing the parameters affecting the
results?
For example;

Hi Guys,
My first post on the forums. I work for a small insurance company in the UK
using MS excel for stochastic modelling. My company has been office 2000(!)
for a ages, and have finally taken the 'plunge' and upgraded... to office