I have to search through column F for the terms "Hat" or "Shoe". If it finds either term, then convert from Decimal format to Fractional format if the value is not a whole number.
I am solving for each stage and have questions along the way. This may jump around some as I will use what I know to assist me in reaching my final product.
This will not be marked as "Solved" for a while, as I will confine my questions to this post to keep continuity.
Q1# In Code syntax I want to add an "Or" condition my current loop is fine until I add the Or "Shoe"
[vba]For i = 1 To Lrow
If Cells(i, "F") = "Hat" Or "Shoe" Then
Cells(i, "M").Value = Cells(i, "M") / 2
End If
Next i[/vba]
Thanks for any assistance...
Doug