I have posted multiple macros in this thread, all of which work correctly. Other people have posted macros too, or links to them. Since I don't know which of my macros you're using, I can't possibly comment on why one of them might not work for you, especially given that you haven't mentioned anything about error messages and the like. As for Greg's macro, you'd need to discuss that with him.
