I declared a book a specific name but and gave a range a
specific range. when I write the formula on an opposing
workbook to count the amount of spaces it comes up as the
formula not the value. If someone could help me out I'd
appreciate it. Thanks in advance.

Jeff


Dim IDS As Range
Dim Fname As String


Fname = ActiveWorkbook.Name

ActiveCell.Offset(0, 7).Select
Range(Selection, Selection.End(xlDown)).Name = "IDS"

ActiveWindow.ActivateNext


ActiveCell.FormulaR1C1 = "=COUNT(FNAME&INS)"

'''This comes out as described above im stumped