Unable 2 use UDF function

[anilyadav]

I try to use this UDF


Function hf(Check_Cell As Range)

hf = Check_Cell.HasFormula

End Function


it will use to highlight the cell which is having the formula


but the problem is that its not working b'coz,

the its appear in UDF is like the:- 'workbook.xls'!mudule1.hf


pls hep how to get the UDF as a HF

 

[Hui]

Make sure it is in a Code Module not a Worksheet or Workbok module in VBA