A user would like to enter ranges in an Excel workbook. What VBA would I use that would label in column C whether the ranges he/she entered are valid or not.
Row Column:B Column:C
1 A1:B200 Valid
2 BC10: DD10 Valid
3 A:B200 Invalid
4 C200:A1 Invalid
The code should say row 3 is an invalid range because it missing the row reference after the "A".
The code should say Row 4 is an invalid range because column "C" is before column "A".