View Single Post
  #1   Report Post  
Sarah Ward
 
Posts: n/a
Default Find and Go to Value

Hi there

I'm running a macro that someone at my work wrote who's now left, and I'm
struggling with one line of it. I know what it does - it identifies the first
instance of a value (ZXYZXY) occurring, and goes to it. But I can't actually
understand the line of code, and I need to.

It goes: WHILE(FORMULA.FIND("ZXYZXY",1,1,1,1,FALSE))
If someone could tell me what each 1 is in place for, and the FALSE etc.
that would be great.

Cheers, Sarah.