Selecting Multiple Cells using VBA in Excel 2013

I thought this made sense, but I'm the only one that thinks so...

What is a way to code this so that it works?

Please Login or Register  to view this content.

Jim Berglund

Try this,

Please Login or Register  to view this content.

Hmm, maybe with the use of a range variable, set the range to the cells desired, then copy them:

Please Login or Register  to view this content.

Jerry, you can use union to select as well. Or did I not understand you?

Please Login or Register  to view this content.

I pasted your code into a module and ran it seems to work fine. Not for you?

In general, my answers won't have "select" still in them, I always guide the OPs toward doing the "thing" directly, whatever it is, instead of selecting first. Personal preference.

That is what I was stating, that you 'could' also use the union for selecting cells. (I did miss-understand your first statement in that case) I agree, that select is generally not used, but I usually just do what to OP asks. Probably not the best thing to do in all cases though.

Heh, understood. I resisted the urge to simply say, "Did you try it?".
That usually doesn't get across I'm just being playful.

Just for variety,

Please Login or Register  to view this content.