PDA

View Full Version : Watches Window: View what row active?



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"

Bob Phillips
07-29-2007, 03:48 PM
Either watch c and drill down to the Row property, or just watch c.Row directly.