what do you mean when you run it? when you try to use it from the Sheet right?

You will get Value! because the Function is not returning anything. Look at my post #2 and you will see in my sample code whats missing.

Can you provide the original code and sample of the workbook perhaps with what you need to do?

Thanks