Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. For j = 4 to 100
  2. Select Case Range("D" & j).Value
  3. Case "ESPN"
  4. Range("D" & j).Value = "773"
  5. Case "ESPN2"
  6. Range("D" & j).Value = "772"
  7. 'etc.
  8. End Select
  9. Next j
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement