I need a macro to check each cell in a range to see if it fits a
certain format. Specifically the format is

LLNNNNNNL

L = letter
N = number

Is there any easy way to do this?

Thanks,
Richard