Stop Function From Running

[realniceguy5000]

Hi,

Is there anyway to avoid a function script from running? I have a script that is running along fine till it changes something in one of the cells then the function script takes over and never goes back to the other script?

Not sure what to do?

I have this say in Range(C67 =findcolor(C4:C49)

Please Login or Register  to view this content.

Thank You, Mike

[davegugg]

What is the intended purpose of this function? I don't understand where the variable j leads, actually the whole line with j is confusing. What is the "other script" that you are refering to?

[Leith Ross]

Hello Mike,

Are you trying to use a UDF within a formula?

[realniceguy5000]

My Mistake, That J line is suppose to be null out.

The function counts the number of cells that are yellow in a range.

The other script is from a userform button push. which changes a cells value when the value changes it fires this function script.

Here is a snipit from that script:

Please Login or Register  to view this content.

When steping through the script when I hit "Rng2.ClearContents" the function script fires but never returns back to the next line in the script above.

The correct Function Script is:

Please Login or Register  to view this content.

Thank You, Mike

[davegugg]

I set up a quick test, but I couldn't mimick your results; code I put after the clearcontents still ran. Did you try stepping through the code to see what happens? What code is next after Rng2.ClearContents?

[realniceguy5000]

Leith, Yes I made this function up with help from snb here.

http://www.excelforum.com/excel-prog...rom-a-sub.html

Then I changed things a bit.

So now I just get the number of yellow cells.

Like in cell C67 = FindColor(C4:C49) I have these Functions in about 9 cells through out the worksheet with differnt ranges of coarse.

Thank You, Mike

[realniceguy5000]

Dave, I was stepping through when I noticed the issue. This was working before I made these functions up. Maybe I should change these functions to subs and fire in a worksheet change, That way I could control when they fire.

But maybe that isn't even the issue. Let me throw some stops in the code to see if really keeps going...

My mind is messed up today...

Thanks for your help... Mike