If Len 5 OR cell is alphanumeric Then Clear contents
Hi there
I've got a macro that doeas a whole load of formatting for me, I'm just
after a final statement that'll look at all the cells in the active
worksheet and clears the contents of the cell if the length is less
than 5 OR there are alphabetic characters mixed with the numbers.
Thanks
|