On Thursday, October 11, 2012 1:12:23 PM UTC-4, Ben McClave wrote:
Hans,



I'm glad to hear that it worked for you. Thanks for the feedback.



Ben

Now have an additional one for you....
You provided this code:
Set rPaste = Sheet2.Range("A5")

I have found I need the same information in an additional location, specifically Sheet2 starting in cell A36.
Tried three different ways
Set rPaste2 = Sheet2.Range("A36")
Set rPaste = Sheet2.Range("A5")&("A36")
Set rPaste = Sheet2.Range("A5", "A36")
Neither works... how would I do this?