I have this function that makes 2 logical tests before it deletes that
value in that cell...

It searchs through a particular column in all rows that contain data
for any value that is not numeric and that is also not of length 3 and
deletes it.

My problem is that it does not seem to be looping, it goes until it
finds the next instance of my condition and then deletes but it does
not look again unless I run the macro again, any ideas.


--
bg18461
------------------------------------------------------------------------
bg18461's Profile: http://www.excelforum.com/member.php...fo&userid=8877
View this thread: http://www.excelforum.com/showthread...hreadid=568312