Copy/Paste Discontiguous columns

[jomili]

I'm trying to copy only the first and last columns from a table into a new sheet, where I want to paste them side-by-side, and am having trouble trying to figure out the context.My code is below. It works, except that instead of copying ONLY Columns 1 and 7, it copies the whole range and pastes it in. Any help straightening out my code is greatly appreciated.

Please Login or Register  to view this content.

[StephenR]

Try this instead:

Please Login or Register  to view this content.

[jomili]

Stephen,

Your code works, but I don't understand why. It seems to me that these three lines all say the same thing, but yours only copys the two columns in question, and the other two copy also the intervening columns. What's the secret to only capturing those two? Also, ideally I'd like to only copy the used range in each column, not the entire column. BTW, "LastRow" below is actually the last Data row, above the Totals, which is why I have the "+1".

Please Login or Register  to view this content.

[StephenR]

Re your first one, this will work:

Please Login or Register  to view this content.

I had a nasty feeling you'd ask why. I'm not sure, Columns must be interpreted along the same lines as the Cells property would be?

[jomili]

Maybe somebody else will tell us? But if not, thanks so much for getting my code going.

[StephenR]

My pleasure. No doubt others here will know precisely why one works and the other doesn't.