This is the second time that you have posted a macro without any explanation or question. If you want help from the members of this forum, you'll need to put a little more effort into your posts.
I'll repeat my response from the thread you started yesterday:
There are 2 issues with your post:
1 - You posted some code, but you didn't actually ask a question. If you want us to help you, you should try to make it as easy as you can for us to figure out what you are doing and what you want done.
You should post something like...
"The following code is used to (tell us what the code does). What I am trying to do is (tell us what you are having a problem with).
2 - Please click on the blue line at the bottom of this post and read the instructions on how to post VBA code in this fourm. By following the instructions found via that link, the code will be formatted in a manner that will make it much easier for us to read. Of course, that assumes that you used indents when you wrote the code.
You'll need to put a little more effort into your posts before we're going to put any effort into answering them.
Office Forum Moderator
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.