i have a cell with a formula in one worksheet that references another
cell. the formula looks like this:
=IF((ISBLANK('Draft'!$D25)),"",'Draft'!$D25)
where 'draft' is another worksheet in my workbook.

HELP
I use multiple monitors and often have to work on a number of files at the
same time.
Word allows me to have multiple windows open and I can mimise them (each

I want to write a macro to delete a column pls hlp
TIA

Column A has 962 entries. Column C has 898 entries. I want to find out,
in Column B, entries that are in column A but not in Column C.
Thanks in advance.
Mazhar

I have about 2000 rows I want to add in a custom list in order to sort
another column that contains 4000 rows. The problem is that the custom list
only uses the first 180 rows or so.  It seems like the maximum rows or items
you can add to a custom list is 180.  Does anybody know ...

Hi, I've never used Macros in Excel before and need to start now.
Basically every so often I receive a list of patients from GP practices in
Excel documents.  The list is dumped in from GP systems and often needs
sorting.  The main problem with the lists is that there are often ...

i've got a drop down list.
i want a default value in the list  and at the same time be able t
change it to a different value if needed.
can anyone help please?

I'm trying to get my head around Excel Programing using VBA. I'm
reading various books, some of which provide examples on CD.
On the subject of named formulas, when I look in the examples using the
define name dialog box, the actual formula completely fills the 'Refers

For some reason Excel links stop working when I enter them manually.
If I copy /paste links, everything is fine. If I type = then point to cell in the other workbook then is fine (sometimes).
I tried in other computers. Is it possible the workbook got corrupted? Why? Is there a ...

I have variables a,b,&c for items 1-5. The range for these variables is
100-1000. There is a fourth varibale (d) that ranges from 1-12. I want
to show in 1 graph that changes in variables a,b,&c are directly
correlated to variable d.

I am using excel 97. How can I set up a password to protect opening or
viewing the spreadsheet? Thanks.

I'm creating a high school directory using Excel 2002. Once in a while I
will get typing a little too fast and turn off Num Lock and then I end up in
the wrong cell.  I'd like to be able to return to the last line in the
table; I thought Ctrl-End would take me there, because ...

i have an excel worksheet that is formatted as such
(number) (date) (conpany name) (street address) (city) (state)
(agent) (agent's name) (agent's address)
(officer) (officer's name) (officer's address)

Is there some way of formatting cells that prevents cell content from being
interpreted as a hyperlink?
Thanks,
Keith