| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
| Clear Cell Contents | Excel Programming | |||
| VBA Clear Cell Contents | Excel Programming | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| vb to clear cell contents | New Users to Excel | |||
Threaded Mode
