I've always been a passive user of this pages which have provided me a
solution to all my excel problems just browsing through these pages.
For the first time it hasn' worked so posting my problem here.
On using the following function excel crashes. Can someone figure out

Hi, can anyone help with this please
I have a table that lists articles published over a month.
I have two (relevant) columns:
Column A (Pulications)

my colleagues are having some problems with a file created by a Excel 2002,
cells appears fine on it. But some cell displays #REF! when opening it with
Excel 2003. Is there a compatibility issue?
TIA

I often work with a spreadsheet in which two of the columns are labelled
Start Date and End Date respectively.  The spreadsheet has about 3000 rows
of data and is replaced with a new spreadsheet every fortnight.
My problem is that when I try to sort the rows by one of these "date" ...

I  have a spreadsheet from Pay pal.
It lists many columns and cells.
For example in one of the COLUMNS (column D) it lists  the words"us postal"
which are postal fees I incurred, for debits and  their are names listed

I was wondering if it was possible to have flashing text in a cell that
contains a formula. And if so is it complicated to do?

Col A has 200 cells (i.e., A1.A200)
Col B has 1500 cells (i.e., B1.B1500)
How can I find the cells in Col A whose contents match the contents in
the cells in Col B?

I am using Excel 2003 and would like to avoid using VBA code if possible.
I have two columns (A & B) with 12 cells used, and a cell further down (C22)
where the sum of Column B is added up.
What I need to do is have Column A have either Yes Or No (I know I can do

Can someone let me know how to make Excel 2003 as my default application
instead of Excel 2007?
Also, I want to know if there is an update that fixes the multiplication bug
in Excel 2007, 850 X 77.1.

I have a spreadsheet from Pay pal.
It lists many columns and cells.
For example in one of the rows it lists "us postal" which are postal fees I
incurred, for debits and  names listed beneath them as credits for paid sales

I would like to set up excel so that if a cell or a range is protected it
will be displayed in a different
colour.
Can any one tell me how to do this.

Let me explain what I am tring to do. I send tissue(leaf) samples from
different agricultural crops to a lab. The send back a report with the levels
of all the essential elements. I then paste them into a spread sheet. there
is a high, low and normal level. These criteria levels ...

OK - So I have text in A1
Then column A is blank down to A(x) (x being and possible number.
Then I have different text in the next row in A. A(x+1).
This happens repeatedly through out about 50,000 records (that rules out

I have made vba-code that makes a formula to be pasted into one cell at the
time in Excel.
The vba-code:
vAktivCelle = "J" & i

I got some advice before but I am still having problems sorting dates. Using
Excel 2003. I have a file of about 1000 records over a time span of 1750 to
1921.
When I sort by what I think is the date the order result is as follows...