I have a cell with a value of example ....A46734
ie first postion is a Charcter and next there are 5 numericals
ie need to validate all values for this cells to fit above pattern and then do something if they do else reject if dont .
how is this easily done in VBA.
does any one know of a function.
i need to know how to check for this pattern and return true or false if doesnt fit pattern
ie first postion is a Charcter and next there are 5 numericals
ie need to validate all values for this cells to fit above pattern and then do something if they do else reject if dont .
how is this easily done in VBA.
does any one know of a function.
i need to know how to check for this pattern and return true or false if doesnt fit pattern