- From: "HK" <a@xxxxx>
- Date: Mon, 25 Jan 2010 16:46:46 +0100
Bob Phillips and maybe many others have provided a UDF like
Function HASFORMULA(rng As Range)
If rng.Count = 1 Then
HASFORMULA = rng.HASFORMULA
HASFORMULA = CVErr(xlErrRef)
Can this function be changed to show an array of TRUE/FALSE values reflecting whether cells in a range holds formulas or not?