|re: "an error is appearing for this macro"|
Are you expecting us to guess at which of the hundreds of possible errors you are getting? Imagine how much more help we could be if you were just a tad bit more specific.
Oh, what the heck, I'll play along.
You are getting:
Run-time error '1004':
Application-defined or object-defined error
Do I get bonus points if I tell you why you are getting this error?
OK, how about this?
Rw = 0
How'd I do?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.