I have a formula that requires to be entered as an array by
CTRL+SHIFT+ENTER in order to execute correctly. I tried to record a
macro with this formula, it says "unable to record macro". The
following is an example of my formula:

=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9), 1)),0),COUNT(1*MID(A1,ROW($1:$9),1)))

which can also be found here
http://office.microsoft.com/en-us/as...549011033.aspx


Any ideas around this?