Hello All,

I was wondering if there is a programmatic way to check the limitations on cells.

For example, if you return values as variants, a string of greater than 255 characters will show #VALUE. If you return the same value as a string, the limit is much higher.

I know that the constant is 255 in current versions of Excel, but I want to make sure that if this limit changes in the future, my functions will also work (and automatically take advantage of any increases).

Thanks,
Paul

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.

 

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".


-----------------------
Regards BrianB
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.