sorry the titel of this thread has nothing to do with the
question. This was not an error generated by an array
formula. Sorry for the confusion.


>-----Original Message-----
>I want to check to see if a cell has a column width which
>is too small relative to the text that is in it. This
>normally generates the ##### error. However how do you
>search for this as the number of #s vary based on the
>width of column vs the text. The code below would not
>necessarily find all the occurences of this.
>
>Case Is = "######"
>
>Thanks
>.
>