Ok ... I weaseled ... "Div/0" error still happens, but now not visible & does
not print.

1: I removed error checking piece from my Formula
2: I set Conditional Format of my Range =iserror(Cell)
3: I set Font color to same color as cell Pattern
4: I set "Print Errors" as "Displayed" to "<Blank"

Now if one of you could kindly tell me how to do this the correct way ...
That would be "awesome" ... I have learned many lessons from this board ...
Thanks ... Kha

--
Kha


"Ken" wrote:

Excel2003 ... I do not usually work between WorkBooks ... I simply do not
like to ... :(

WB1 (Cell D3) ... AVERAGE Formula pulling from <= 10 different WB's (Cell
D3) ... (Works great as long as there is a "value" found)

Issue ... When other 10 WBs (Cell D3) is null ("") (hope I am using the
correct term?) ... My AVERAGE Formula WB1 (Cell D3) is returning the "Div\0"
error.

My fix ... =if(iserror(Average etc etc),"",(Average etc etc)) ... issue here
became length of my Formula because of Drives, Folder Trees & FileNames etc
... Fix ok until Formula to looooooooooong.

Help from any intimate with Excel would be welcome ... Thanks ... Kha


--
Kha