I get the following error message while I'm using my workbook.  I
don't know how to evaluate it:
"A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name,

I have a created a trend . However for a couple of year data points
the values are blank. Since there is formula embedded in those cells I
really dont want to touch it. So when I graph over it it would show as
0 . In graphs we would be seeing all Zig Zag lines. If I want the data

I need a formula to calculate total days (working days) that excludes
holidays, but includes weekends.   The networkdays formula doesn't work since
we work on weekends and have variable days off.  I wanted to put the select
days off( some weekdays and some weekends in a holiday ...

I have the following spreadsheet which I attempting to calculate the Prior
Years Inventory Level in actual Retail $
I have a database query that retrieves the following Information:(
DeptDate( week end date(Saturday), OH Retail$, % Chg Prior Year), DeptNum

I have taken information from other sources and want to count how many rows I
have without physically counting them as they have been inserted into the
worksheet out of sequence.  Is there a way to do this?

Excel 2000
Is there a way to color-code a row based on a condition of one cell in
that row, but not using Visual Basic Editor? Conditional formatting
would be perfect except I am only allowed 3 conditions.   I have a

Hello, does anyone know how I can look at a cell without seeing a special
character? I need to determine a length by subtracting one cell from another
but the numbers in the cell are engineering stationing in the format
xxx+xx.xx (300+45.10). I need to use this data to get the ...

Private Sub Worksheet_Change(ByVal Target As Range)
' Do Something
End Sub
I have the above code in Sheet1 of my Workbook.  When I Insert a new

I have a single cell named BRHCTS in several excel files.  It
indicates the bottom-right-hand-corner of the range I am interested
in.  The upper right hand corner is always the cell A10.  Therefore,
the range I want to copy from each of my files (into a consolidated

If I have the following cell values:
B6 contains A
C6 contains 5
D6 contains .35

This problem just started. When I double click an Excel file from a file
folder I get an error window that pops up that says can't find file. It
keeps saying that several times and then it finally opens the file.
Apparently if the folder name has any spaces in it Excel attempts ...

In my workbook I have several worksheets. In cell B2 of every worksheet,
there is an average from the data in that worksheet. As this is a
template, some data is not entered yet, and some B2 cells show error
(div by 0). Now, I wanted to calculate the average from B2 cells of all

How can I do this please?
Chris

Thanks a lot

------------------------------------------------------------------------
A poll associated with this post was created, to vote and see the
results, please visit http://forums.yourdomain.com.au/showthread.php?t=844016