Originally Posted by
whatsmyname
Hey Foxguy,
Not a problem at all. You're helping me and I greatly apprciate it.
Where do I put this code and how do I run it? Do I add it to the previous VBA that you wrote? I noticed that it is a function. Also, I noticed a message box in the code. I was curious if I could get the reslults to be displayed in a cell?
Sorry about the function. Just change it
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).
Bookmarks