Is there a trick to get around the 255 R1C1 character limit? I am trying to convert a formula to an array but get a run-time error '13' type mismatch error. I then tried to use named ranges to breakup the formula into pieces which shortened the formula...it worked, but it took WAY too long...