-
For-Next Loop Help
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
Last edited by YellowLabPro; 07-24-2007 at 08:40 AM.
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules