I have a load of values in a spreadsheet which are either true or false.
I need to count how many times it changes from false to true, bearing in
mind several true values may follow each other - before returning to false.
ie

I just want to write email addresses on the worksheet cells. How can I
prevent this f...ng Excel from automatically changing them to mailto:
hyperlinks.
"I miss my Lotus"

Bernie
Forgive me for jumping in on this, you seem to be the only person that
has put forward a code that works first time. I ought to mention I am
very new to all this and just getting my head round it.

I am ranking some data using the following formula (which I thought prevented
duplicate ranks occuring), but I am getting duplicates in my ranking:
=RANK(CE2,BoysExtraCurricular)+COUNTIF($CE$2:CE$2,CE$2)-1
Can anyone suggest what I can change in the formula to get rid of the

I have multiple rows of data, each one starting with a number. If the
number in the front of the row changes, I need that whole row to be
highlighted. Then I need a check box on the other side of the row so
that I can turn off (reset) the highlighting.

I'm attempting to figure out how to copy a variable length of data
from one worksheet to another.  They're both in the same work book.
One sheet is the Order sheet and the other is a credit card tracking
sheet.  The columns don't match up and are orientated for ease of

Having upgraded to Office 2007 (XP Pro, 1 Gb RAM Pentium 4 2.4GHz) I am
finding Excel to be painfully slow even when opening small (50k) files by
double clicking either the file or a shortcut.  If I have Excel open and go
through the ribbon menu to open the file from within Excel ...

I have a excel worksheet with bunch of columns.
Now I want to create a new excel sheet with only selected columns.
And user will be prompted to input the columns may be with a inputbox only
for onetime.

I have created a formula using IF,THEN,ELSE but, I now find that my IF
argument needs to refer to two cells.
i.e.
=if(a1<=0,(and)b1<5,0,A1*b1)

In Excel when I press the alt key and F11 I get the Visual Basic Window.  I
don't want the user to see all the coding behind the various sheets, forms,
modules etc.   How do I password protect this? I try sheet protect, but I
can still see the Visual Basic Window.  Thank you in ...

I need a solution on data validation. I set the list in the different
worksheet and can choose the data from the drop down box. What i need
is to enter data by typing as well as from the list and when i insert
a new data by typing it should be included in the list thereafter.

My god, I have some excel file, the data sheets have so many columns,
and I need order like following,
1.1.1
1.1.1.2

I am trying to get a formula to count the number of outstanding letters by
member of staff.
I am trying to use the countif function with the isblank function (ie the
date of response isn't filled in).

I like to write a macro that will clear the content of a sheet only if the
fields has numbers for example 348,000, but not a formula field like =Sum().
Also if the field is a text and have a number I don't want to touch it.  Is
this possible? Any tips will be apprecated.  Thank ...

I tried all buttons in an excel worksheet in order to put the page number in
the middle of the sheet as a watermark, but it i could find out how????
Please if anyone can help me with a reply.Thanks