YellowLabPro
07-29-2007, 01:50 PM
What part of the code would I use in the Watches Window to view which row I am in w/out having to view it in the Locals window?
LRowF = Cells(Rows.Count, 1).End(xlUp).Row
For Each c In Range("M4:M" & LRowF)
Select Case c.Value
Case "Xs", "Xsml", "Xxs"
c.Value = "Xs"
Case "S", "Sm", "Small", "Sml"
c.Value = "Sm"
Case "M", "Md", "Med", "Medium"
c.Value = "Md"
LRowF = Cells(Rows.Count, 1).End(xlUp).Row
For Each c In Range("M4:M" & LRowF)
Select Case c.Value
Case "Xs", "Xsml", "Xxs"
c.Value = "Xs"
Case "S", "Sm", "Small", "Sml"
c.Value = "Sm"
Case "M", "Md", "Med", "Medium"
c.Value = "Md"