I guess the way to handle this would be to attempt to insert a gradually increasing size string into the cell and trap any error produced.
quote:I know that the constant is 255 in current versions of Excel
This is true of Excel 97 but 2000 up will take more (but only display 255 I think ??). Later versions
Have a look at your Excel Help under "limits in Microsoft Excel".
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.