I was wondering whether there is a function in Excel (or if it is
possible to write a Macro) that allows you to change the formula within
a given cell to just its value (that the formula calculated), if a
certain condition is met.

(NOTE: This was previously posted to public.excel group)
Using ASP 3.0, I give the user the ability to create a spreadsheet with a
click. In the resulting spreadsheet, I have 2 columns which contain dates,
and which were created by almost exactly the same code, yet they behave

how to use calendar control in excle 2003
Regards
sreenivas reddy

This is the first column
Column A
Abdul Narayan D'souza
Sujit Satyadhar Shukla

I hava a workbook with 2 worksheets.
Sheet1 consists of 3 columns:
column A: invoice number
column B: "H" or "B" letters

How can I get Exel to display every (eg) 35th row only?

When I enter a figure into a cell and click onto the % icon, it doesn't
simply add a % sign at the end of the figure, it changes it into something
else altogether - what is it doing?
Also, if I then delete the figure and enter another one, it does just put

I have entered some error checking formulas into a worksheet to ensure the
user is aware that someone was missing or entered incorrectly.  However, the
user must look at the error columns to see the messages (they can filter on
the columns for the messages).  

I'm having a little problem, recently I wrote a formula for excel which is
too long so I have to decide between trying to find away too shorten that
formula (i'm not sure if it's possible) or written some of the formula code
in vba ?

I have a problem that I can't seem to find any reference in books to help.
The scenario is that I have a multi-sheet workbook, sheet 1 (Master Work
List) contains the details of all the work that we have assigned, one row per
task. One of the details in the task is the developer ...

Is there an excel funtion that retreives the last cell of a list that
contains data. And then one that will find the next to the last, etc. The
list, or series kees getting longer but I always want to link a cell in a
table to the last data of the list, at the end of the list. ...

I'm using a simple Countif in XL2003 so don't need to CSE it. It fights with
a named range and I cannot see why. It worked when I set it up, but the
moment I changed anything it stopped. Where am I going wrong?
Given a 50-cell range $B$20:$B$44 and $B$56:$B$80 named as F_Shell.

Is it possible to hide the value of a cell if the cell throws up an error
message such as #N/A.
I have a workbook in which I have a formula that will fill a specific cell
based on scores in another couple of cells. Because the cells are not filled

How can I use COUNTIF to count the values in a range which are greater than 0?
I put =COUNTIF(B2:B100000)>0 but that didn't work?
(I'm using XL 2007 hence the range greater than 65000 rows.  But I don't
think COUNTIFs syntax has been changed in 2007 so I assume I'm having a brain

Will it be possible to add a variable as a parameter for the link? as shown
below format, therefore, I can change its parameter based on certain cell
value to link different spreadsheets? for example
Original