What VBA would I need to validate a string can also be a range?
Assume I have a sheet where the user enters text in A1. If the text can be a range like "B20" then show a message box that says, "This is a range!!"
"A1" = True: It is a range
"2-2A" = False: is not a range