Thread
:
Entering Data into Column C based on word from Column A
View Single Post
#
2
Posted to microsoft.public.excel.programming
merjet
external usenet poster
Posts: 812
Entering Data into Column C based on word from Column A
Dim c As Range
For Each c In Sheet1.Range("A2:A9")
If InStr(LCase(c), "dog") 0 Then c.Offset(0, 2) = "Doggy"
Next c
Hth,
Merjet
Reply With Quote
merjet
View Public Profile
Find all posts by merjet