Hello Experts
I have found a VBA that changes the value of cells in a column to uppercase, but the problem is i am getting a Run-time error '13' Type mismatch
I think the reason is because the cell contains both alphabets and numbers
What do I need to change in the VBA that it would accept alphanumeric data and only change the alphabets to uppercase?
What I am entering into the cell is in this format aa-c8292 and want the VBA to change it to AA-C8292
The VBA i am using is below, any help would be greatly appreciated
Regards
Rahul
Bookmarks