HYCH
My question is:
I have a range from H2:I32, within this range i have values of 1 and 0
spread throughout,

I have one particular file in Excel 97  which I open and update daily
(stock market stuff) and each day I copy the days entries and paste it
below for the next day.  Been doing this for years with no hitch until a
couple of months ago then one day I tried to open the file and got a

Using Excel 2003 - I've protected the cells and turned on the "Sort" option,
which to my knowledge, will allow the users to Sort the data, even though
it's currently locked.  But it doesn't work!  When I try to sort, it tells me
I can't becuase the sheet is protected.  

It appears that the countif function (along with sumif and others i'm
betting) do not function properly with external links. The only
workaround I've been able to find is to write a macro to open the
various externally referenced sheets and then close them. Is there a

Is there a way to determine if a cell contains a formula
or a value?  The ISxxx( ) and CELL( ) functions don't
appear to be able to do this.
I want to use conditional formatting to show if a cell

In a cell with a SUM I need to put 0 when the sum is negative.
For example, X=Z+Y+W. If X>=0 ==> I want to put the right value.
BUT IF X<0 I want to have 0 in the cel!
How could I do this?

I am making forms and want to know how to import information from sheet 1 to
sheet 2 or 3 or so on.
Like sheet one in A1 FIRST NAME:
                        B1 MIDDLE NAME:

I'm not sure if this possible, but is there a way to format some cells
so that they have to have information put in them. I know it's
possible in Access, but when tabbing along a row I want to be able
have the cursor not move out of the cell until information has been

Hey Guys
I intend my macro to do this:
If autofilter is activated then show all, if not then activate
autofilter .

one of my students presented me with the following:
"I get a list from another application.
There is a column that has either value "yes" or looks like empty.
Now, when I want to jump to the next row that has value "yes" I use the

For quite some time I had an Add-In working fine, now it is gone...
It is still listed in the Tools manu and checked, but it does not open!
What do I do wrong? When looking for it, I tried to open the file, but
nothing happend.

I had an issue of how to populate my combo box with unique values only,
after some research I discovered collections and how they dont allow
duplicate values and I could simply skip the error to achieve the results I
wanted.

When I save a file in Excel 07 in an older format the file size is huge
compared to the orginal.
example.  I open a excel 03 file in excel 07 and when saved with excel 07
the size of the file huge from 20kb to over 4megs.  what can I do to fix

Hi, I hope you don't mind a newbie asking newbie questions? :)  I'm a filling
short of a sandwich when it comes to excel, so please keep that in mind if
you decide to be so kind as to respond.  Thanks!
I am trying to get the total hours and minutes worked over two periods to

I have a spreadsheet of a rather large stocklist.  I use this to check off
the price charged on the invoice when we receive the goods, against the
quoted buy price in the spreadsheet. Column A3 - A8000 (ish) contains a
product code; B3 = description; C3 = buy price; D3 = sell ...