Every month I work out the max and min for a range of income types
over the last 24, 18, 12 and 6 months.
As well as displaying the max and min result, is there a way to also
select which of the months was the max and which was the min so it can

how do I print a mailing list to envelopes using a spreadsheet from Excell?

Can I add adding a worksheet in a macro? How do I do that?
Ex. I create a new macro. One of the steps in my macro is to insert a new
worksheet.

Each Month I receive a CD with an excel spreadsheet( call it Input
Spreadsheet). Each row contains certain fields that I need to use to build a
spreadsheet( call it Load Spreadsheet) that I will use to import/export
into Access. However, there is a different number of rows each ...

I am currently entering production details for an order but until
there are actually sufficient components available. the order remains
"on hold". I leave the cells unshaded ( i.e. no colour fill) to
indicate that the order is not yet in production. Shortfall items are

I'm having a problem with a particular spreadsheet. Some of the cells have
dates, typed in MM/DD/YY format, but Excel isn't recognizing it as a date. It
won't change the date format (to MM/DD/YYYY) or sort these dates along with
other "normal" date cells.

Is it possible to populate a combobox.List property with a Range?
I know its common practice to use Array, wondering about a Range.
I've experimented with :-
Dim R As Range

I have a workbook set up for my company. I have to invoice my employer
for payment of services. All set up and works great. I would like to add
one more feature if possible. When I fax an invoice to my employer; is
it possible to have Excel record that automatically in the ...

How (insert / picture) picture stay on the sheet , I can work the sheet
,too.

I am trying to figure out Excel, and have not used it much.
What I need to do is put in a money amount, lets say $5 and the rate per
minute is $0.025 (2 1/2 cents) a minute.
I need the total minutes available with the total amount of money entered at

What formula do i use???
here is my problem... i have 3 columns
A- Qty of days eg: 6, B-start date, eg: 10/12/07 C -end date, , (formula i
am using, (colummn (C) =A+B+1 (copied down the column) this gives me an end

I have column A containing the names of all worksheets in the workbook.
I can enter a formula e.g  ="Sheet1"!D1   which gives me the contents of
cell D1 on Sheet1
How do I enter a formula that substitutes the sheet name from another cell?

I've created a Pvt Table which contains 6 fixed columns and it will show data
depends on how many columns I wanted to see. In addition, I've created
another set of columns to copy data shown on the pvt table. So here is my
question, is there a way to activate cells with data on ...

I have a cell that I wish to require have a value entered if the cell
before it contains a specific value.  In this case, the cell values
are either "1-Yes" or "0-No".  Using the Left() function, I can obtain
either a 1 or 0 value.  In an adjacent cell, if someone has selected

My Scroll Lock is ON, but I can't find the keys to turn it off. The NUM LOCK
is clearly marked, but not my SCRL LOCK. I have a Compaq NC6400.
Can anyone help?