Unabe To Record

  • Thread starter Thread starter DC
  • Start date Start date
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"),"")
 
You can define names for parts of the formula,
for instance

OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER")

can be named to something and so on
 
How do you do that?

-----Original Message-----
You can define names for parts of the formula,
for instance

OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER")

can be named to something and so on
--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top