I have a problem with a macro which has been created on Excel in English.
When it runs on an English station it's ok. When I launch it on a pc with
Excel in French There is an error. Have you any idea about this ? When I
just change the language parameters from french to english, ...

Ignore this posting test.  Sorry, but I need to use this group for my purpose.

Excel 2002
Any one know how I can sum all the cell values in a column except the value
of the last cell to be entered which could be say half-way down the column?
Is there a function to exclude a particular cell from "sum" ?

I have 1 column with "item numbers" Which can be both numbers and
letters.
I wan't to sort them as numbers so that all numbers would come 1st and
then item numbers like KK1992991. The thing is that excel seems to

Morning All
I am making a spreadsheet with a number or 'pick lists' (or drop down menus)
Is there any way I can have the 'down arrow' showing before users actually
reach the cell?

I've just installed Excel 97 on a new computer. It works fine when I start
Excel first and then open a file. But when I double-click on the file to
start Excel, it opens the file all right but then warns me that that file's
already open and I "cannot open two documents with the ...

Thx that will help with part of my problem but how would I make A16
variable.........for instance.....the last cell I enter could be A17 not A16
but I don't want to keep going back to my formula to amend it........
"Ardus Petus" <ardus.petus@laposte.net> wrote in message

I'm trying to create a macro that will execute the funcyion below on a
three columns of data (C, E,F). The columns can vary in length from 26
to 60+ entries.
How do go about doing this?

I need to convert MS Works .wdb files - unknown version -  to Excel 2003.
Do you have or know where I can download a free converter.  It is only
needed for a couple of files.
TIA

How can I get the task pane to come up in Excel?

I am using Excel 2002.
On cell A1, I have text "Apple",
On cell A2, I have text "Banana".
I also have a powerpoint file with two text boxes

I don't expect to get any bites on this one, but, "Hey, it's Friday -- it
could happen!"
Just got this one dropped on my lap -- we have a spreadsheet with items that
we depreciate -- this spreadsheep has been touched/maniulated by many over

How do I integrate a long custom formula in a macro ?
The formula will be used to manipulate a column of data.
Do I record myself actually typing the formula while I record the macro?
Is there an easier way?

I have an example where the First and Last Name of my contacts are in a
single column. I would like the  first and last name in separate columns
ie:   John in Column A  and  Brown  in column B  any help would be
appreciated.

I have 13 separate worksheets with certain data; one worksheet for each month
of the year, and one to summarize the monthly result of the average, the
standard deviation, max and min of the data. For example, B25:M25 lists the
average, B26:M26 the standard deviation, B27:M27 the ...