No, no error, the fault was my own. I didn't set it up as a "With" statement. I just used the setrng without it not realizing it was a with statement. When I got the compile error, I went back and saw what you put. I changed my code to that, and it worked, but now I have another question. I basically want to do the same thing, however this time I have 3 different sets of ranges I want to use, 2 on one worksheet and one being on a different worksheet all in the same workbook. These ranges will always be constant, so I tried the code below, but obviously it didn't work:
I didn't use the with function since the ranges weren't going to change size. Is this a simple fix too?
Bookmarks