kroz
11-12-2010, 01:18 AM
Hey guys,
I'm trying to record a macro with a formula in a workbook, formula that is quite long.
And by record i mean that I've already written the formula in my cell, then pressed Macros record and then clicked in and out of the cell.. the usual stuff.
Only this time EXCEL says "Unable to record".
The formula is this:
=IF(AND($E10<>"",OR($E10>$T$6,E10<$S$6)),IF(ISNA($D10),IF(AND($B10<>"", _
ISNUMBER($B10)),"Error in PID/Error in property ID/Error in Material","Error in PID/Error in property ID"), _
IF(AND($B10<>"",ISNUMBER($B10)),"Error in PID/Error in Material","Error in PID")), _
IF(ISNA($D10),IF(AND($B10<>"",ISNUMBER($B10)),"Error in property ID/Error in Material", _
"Error in Property ID"),IF(AND($B10<>"",ISNUMBER($B10)),"Error in Material","OK")))
Is it too long for VBA?
I'm trying to record a macro with a formula in a workbook, formula that is quite long.
And by record i mean that I've already written the formula in my cell, then pressed Macros record and then clicked in and out of the cell.. the usual stuff.
Only this time EXCEL says "Unable to record".
The formula is this:
=IF(AND($E10<>"",OR($E10>$T$6,E10<$S$6)),IF(ISNA($D10),IF(AND($B10<>"", _
ISNUMBER($B10)),"Error in PID/Error in property ID/Error in Material","Error in PID/Error in property ID"), _
IF(AND($B10<>"",ISNUMBER($B10)),"Error in PID/Error in Material","Error in PID")), _
IF(ISNA($D10),IF(AND($B10<>"",ISNUMBER($B10)),"Error in property ID/Error in Material", _
"Error in Property ID"),IF(AND($B10<>"",ISNUMBER($B10)),"Error in Material","OK")))
Is it too long for VBA?