Thread
:
Loop Through Text and Test for Scenarios Q
View Single Post
#
19
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 73
Loop Through Text and Test for Scenarios Q
Instead of re-doing the whole code I tried to appendix below, but it returns <blank in Col H. Note D is <0 and E is 0
Case "XYZ"
myStr = IIf(Len(c.Offset(, 1)) < 0 _
And c.Offset(, 2) = 0, "Top Level", "")
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]
Loop Through Text and Test for Scenarios Q