Hi,

Instead of using Application.Union,

 Application.Union(Range("EP" & j & ":EP" & i), _
                          Range("ER" & j & ":ER" & i), _
                          Range("ET" & j & ":ET" & i), _
                          Range("EV" & j & ":EV" & i), _
                          Range("EX" & j & ":EY" & i)).Select
can we select multiple column using Range("xx,xx,xx,xx,xx") with upper bound (j) & lower bound(i) ?
I have tried this but got error
 Range("EP & j & :EP & i, ER & j & :ER & i, ET & j & :ET & i, EV & j & :EV & i, EX & j & :EY" & i).Select
can anyone help me?