The code you find at John's site does work with Excel 2003.

To use it................

First make a good backup of you workbook.

With your workbook open, hit ALT + F11 to go to Visual Basic Editor.

Hit CTRL + r to open the Project Explorer.

Select your workbook/project and right-clickInsertModule.

Copy and Paste John's code into that module

ALT + q to return to the Excel window.

Select your non-contiguous ranges to copy by using the CTRL key + click

ToolsMacroMacros and select the macro and run it.

You will be asked to select the top left cell of the paste-to range.

Select another worksheet and a cell and OK.

Paste will preserve the spacings you desire.


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 01:42:01 -0700, capnhud
wrote:

I would like to be able to select multiple rows, columns or cells and then
paste the information into a different worksheet or workbook. But every time
that I try to accomplish this I get an error that the copy command does not
work on multiple selections. Is there a way around this?

I found this page http://j-walk.com/ss/excel/tips/tip36.htm that may help
solve the problem but I do not know how to use it or even if it will work in
Excel 2003. If it can't how do I go about modifying it so that it can be
used? Any help in this would be greatly appreciated.