I have 2 questions.
1. how to insert a worksheet and rename it
  e.g. I want to add/insert a worksheet and name it "Summary"
2. how to detect the existance of a worksheet by name and then delete

I want VBA to save a file using SaveAs and have it replace an existing file.  How do I make it not display the dialog box telling me that the file already exists and asking if I want to replace it?

I am not a mathematician expert, and I would like to do a spectral
(Fourier) analysis of a series of values. For example I have a serie
of 24 values every 15 degrees (over 360 degrees), and I would like to
find out if there are cyclicities in this serie (N=2, 3, ...). I am

I would like the result "CHECK" in this IF Statement to
be Bold and Red. Is it possible ??
IF(G8=D8, "OK", "CHECK")

is there a way to link data from a row to a colum?
Any help will be appreciated.

Is there a way to calculate the minimum value of a group
of cells, but to ignore any zero (0) values in the
minimum calculation?  For example, if the individual cell
values are 0,3,12,0,2, I want the expression to return a

Was wondering if someone has a compilation of the Keyboard
shortcuts that can be used with Excel.

How do I create a macro to find duplicate entries within
a column?  I have a column filled with addresses, and I
want to delete duplicate addresses.
Thanks!

I need help.  My company is working on it's price books and I need to
find out how I can get an answer to come out of the nearest NICKEL...
Each cell that is a price, is an equation of a base price times a
multiplier.  I need to make that answer round to the nearest five

Help requested please....
I want to automatically populate a cell with a value if
another cell is equal to zero. However, I do not want the
cell that is being populated to contain a formula because

I need to create a formula in my spreadsheet that says -
If the number in A1 is between 0-24, enter 25. If the
number in A1 is between 25-49, enter 50. If the number in
A1 is greater than 50 round up to the nearest 100 (i.e.

When you use cells containing formulas that return empty
double quotation marks in the plot range for a chart, the
result for the point values of those cells is zero. For
example, a line chart shows a continuous line going from

Source file - receive everyday and it named as 01.24.04abc.xls
01.25.04abc.xls,01.26.04abc.xls and so on
Lookup File -
Date           Lookup Value

TIA everyone, i don't know if this is possible, but i'd
like to see if i can figure this out in spreadsheet
format.
I have 7 people and 3 locations and 11 months. One

I want to create a formula so I can check if values in
column AC (cells 4-846) are above 60.  If yes, I want to
use the cells in the corresponding rows from column H to
obtain an average.  In other words I want an average from