Have you tried recording a macro? The macro recorder gives you the basic code you need, though it could do with come tweaking. Besides which, where do you want the copied columns to end up in the destination sheet?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|