View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default End If without Block If Error Help

the other thing is that in this syntax:

If Range("I2").Value Like "OPPORTUNITY" Then _
End If


you don't need a "_" at the end of Then.
:)
susan