D
DC
A B C D G H
CLOSE OUT 3/15/04
OTHER 1/15/04
MARCH 6/16/04
I am trying to record the following formula in H using a
macro and receive UNABLE TO RECORD after typeing the
formula.
If this is not the correct newsgourp I am very sorry for
posting here.
Any help on UNABLE TO RECORD is greatly appreciated.
'=IF(OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER"),CHOOSE
(MATCH(G5,--(YEAR(G5)&{"-01-01","-01-15","-02-15","-03-
15","-04-15","-05-15","-06-15","-07-15","-08-15","-09-
15","-10-15","-11-15","-12-15","-12-
32"})),"JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","J
ULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER","
JANUARY"),"")
CLOSE OUT 3/15/04
OTHER 1/15/04
MARCH 6/16/04
I am trying to record the following formula in H using a
macro and receive UNABLE TO RECORD after typeing the
formula.
If this is not the correct newsgourp I am very sorry for
posting here.
Any help on UNABLE TO RECORD is greatly appreciated.
'=IF(OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER"),CHOOSE
(MATCH(G5,--(YEAR(G5)&{"-01-01","-01-15","-02-15","-03-
15","-04-15","-05-15","-06-15","-07-15","-08-15","-09-
15","-10-15","-11-15","-12-15","-12-
32"})),"JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","J
ULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER","
JANUARY"),"")