dynamic formula
hi,
i have the following:
Range("AJ8:AJ" & lastrecordNew2).Select
Selection.Formula = "=IF(ISERROR(BB8/BC8),'No Data',BB8/BC8)"
but i have a problem with this because its not working right. i think it
has something to do with the syntax or something around the No Data.
how can i fix this?
thanks in advance,
geebee
|