Hi,
Instead of using Application.Union,
can we select multiple column using Range("xx,xx,xx,xx,xx") with upper bound (j) & lower bound(i) ?![]()
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
I have tried this but got error
can anyone help me?![]()
Range("EP & j & :EP & i, ER & j & :ER & i, ET & j & :ET & i, EV & j & :EV & i, EX & j & :EY" & i).Select
Bookmarks