View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Code is skipping stepps

what does Vlbl say (coding)?
susan


On Jul 18, 1:19*pm, KWhamill
wrote:
* Apparently I have told the Code to skip this step I just don't know what i
did wrong:

With Worksheets("Entries").Rows("1:7")
* * * * Set Crnc = .Find(what:="Currency", LookIn:=xlValues)
* * * * * * If Crnc Is Nothing Then
* * * * * * * * GoTo Vlbl <--------It goes straight here
* * * * * * * *Curr *<------This is the Sub it's skipping
* * * * * * End If
* * End With