Oh okay. So use .Value2 whenever it works for me, since it's fast.

.Value use it when I want to get some date or currency format that works for me.

Thanks for the clarification and by the way, I think the attached file is blank, although thanks to the fact that you put the code in the post, I was able to copy it and run the macro