Hi ,
You can use a UDF in Excel 2003 compatible with the Excel 2007 IFERROR
function:
*Function IFERROR(ToEvaluate As Variant, Default As Variant) As Variant
If IsArray(ToEvaluate) Then
IFERROR = IIf(IsError(ToEvaluate(1)), Default, ToEvaluate)
Else
IFERROR = IIf(IsError(
hi,
use ISERROR for any version
On Jan 11, 2011 7:41am, Dave Bonallack wrote:
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1&"D$65")*1,"Linked Workbook not open!")
But I do
Hi,
If you are using xl2007 or more, you can use the IFERROR function.
In your case, I think the syntax would go something like this:
=IFERROR(INDIRECT(A1&"D$65")*1,"Linked Workbook not open!")
But I don't have XL2007 here to check it.
Hope this helps.
Regards - Dave.
> Date: Mon, 10 Jan 2011 0
