View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] phil.emmott@baesystems.com is offline
external usenet poster
 
Posts: 2
Default 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