you could establish a formula where you count the number of characters
being displayed when the column width is 50 and then how many chars are
displayed with the width is 60, 70, ...
Then if the text in a given cell exceeds the number of chars you counted
for a given width - you can perform some action - widen the column
programmatically, bring up a messagebox, ...
Rich
*** Sent via Developersdex http://www.developersdex.com ***