Hello all,

I need to populate a range with a very long formula.
It's length exceeds the 255 character limit.
Does any of you know a way to circumvent it.

This is what I have, but what doesn't work because of the length.

    With Worksheets("DATABASE").Range("T7:T100")
         .Formula = "=IF(RC[3]="""",TEXT(HOUR(RC[-8]-INDEX(MISC!R5C14:R100C14,MATCH(LEFT(RC[-17],2),MISC!R5C13:R100C13,0))),""00"")&"":""&TEXT(MINUTE(RC[-8]-INDEX(MISC!R5C14:R100C14,MATCH(LEFT(RC[-17],2),MISC!R5C13:R100C13,0))),""00""),IF(RC[3]>(RC[-8]-INDEX(MISC!R5C14:R100C14,MATCH(LEFT(RC[-17],2),MISC!R5C13:R100C13,0))),""-"","""")&TEXT(HOUR(ABS(RC[3]-(RC[-8]-INDEX(MISC!R5C14:R100C14," & _
                    "FT(RC[-17],2),MISC!R5C13:R100C13,0))))),""00"")&"":""&TEXT(MINUTE(ABS(RC[3]-(RC[-8]-INDEX(MISC!R5C14:R100C14,MATCH(LEFT(RC[-17],2),MISC!R5C13:R100C13,0))))),""00""))"
        .Value = .Value
    End With