Hello Poopdish,
The best method is to examine the cell's length at the time of input. The cells could be examined whenever you decide to run the macro. However, checking all the used cells on a worksheet, especially a large sheet, could be quite slow.
This example examines the cell's length at input.
To Install the Macro:
1) Copy the Macro using CTRL+C.
2) Right Click on the Sheet's name tab the macro will be run on.
3) Click "View Code" from the pop up menu.
4) Paste the macro using CTRL+V.
5) Save the macro using CTRL+S
Sincerely,
Leith Ross
Bookmarks