Copying Every Other Column

T

tom

In Excel 2007, I have a spreadsheet with 14302 columns and I would like to
copy everyother column without having to select them one-by-one... Any help
would be greatly appreciated.

TFTH,
 
J

John_McGhie_[MVP]

That's a job for VBA. Ask the nice folks down the hallway in the Excel 2007
for PC forum how to do that. This is the Excel for Macintosh group...

Come to think of it, Mark Grimes has a solution here:

http://www.peculiarities.com/code/excel.html

Cheers


In Excel 2007, I have a spreadsheet with 14302 columns and I would like to
copy everyother column without having to select them one-by-one... Any help
would be greatly appreciated.

TFTH,

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top