Tag Archives: UpperCase

A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase. Create a macro: sub MakeUpper() for each myCell in Selection   myCell.Value = UCase(myCell.value) next myCell end sub Add a … Continue reading →