Sorry about the function. Just change it
Originally Posted by whatsmyname
be sure and delete the "As Boolean".
My error trapping is dependent on it being a Function. It works exactly the same as a Sub. The main difference as far as you are concerned is that it doesn't show up on the list of macros to run.
Put it in any Standard Module, probably the same module where you have "Separate".
I put the message box in just to show you that it works. It's up to you to put the value where you want it, (and delete the msgbox).