Hi all,
I have VB function that sums cells by the font color in my workbook an
I use this function on a linked file in this way:

=SumFontColor($A$1,'C:\LOGISTICS\A4\[NEW BOOKIN
SUMMARY.xls]N.BLDG'!E41)

For some reason all cells appear as "#value!" if the linked workbook i
closed
,if the linked workbook is opened all values appear as they should...


What am I doing wrong?

Please advise,
Thanks Yaron

p.s.

here is the above mentioned function:
Function SumFontColor(rFColor As Range, rFSumRange As Range)

Dim rFCell As Range
Dim iFCol As Integer
Dim vFResult

iFCol = rFColor.Font.ColorIndex

For Each rFCell In rFSumRange
If rFCell.Font.ColorIndex = iFCol Then
vFResult = WorksheetFunction.Sum(rFCell) + vFResult
End If
Next rFCell

SumFontColor = vFResult
End Functio

--
Message posted from http://www.ExcelForum.com