Hi,
I want to grab rngCopy in my loop of sheets.
Problem: the code below selects all cells between columns C & H.
Desired result: I want to ONLY select cells between C thru D AND cells in H but not the cells in between (just like this code would if rngCopy=9 -- Sheets(i).Range("C7:D9...