Excel macro to select the first value in cell in a specific column
Posted on 2014-12-12
I'm attempting to create a VBA macro in Excel that looks at a specific column (column D) which contains values of "male" and "female". It then needs to convert those to M and F. I've created the following macro that does this. However in it's current construction the user must select the values in the column. I would like to set the macro to run for a specific column D and change the values there. Please help.
Dim c As Range
For Each c In Selection.Cells
c.Value = UCase(Left(c.Value, 1))