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.

hi,
When u select the cells in a work sheets, after copying it, select only
one cell in the new sheet and paste the data. Do not click more than one
cell in the new sheet.

"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.

Hi and thank you for the response, but when I paste into the new worksheet
instead of maintaining the separations of the rows and columns everything
just wound up being close together instead maintain it distinct row and
column spacing

"Zoya" wrote:

hi,
When u select the cells in a work sheets, after copying it, select only
one cell in the new sheet and paste the data. Do not click more than one
cell in the new sheet.

"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.

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.

Just was not sure if I could use it or not. But it seems the download
provides an exe file do I just install the code instead?

"Gord Dibben" wrote:

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.

My instructions are for just copying the code from the site and pasting to a
module.

You also have the option to download a workbook with the code already in it.

I find it easier to copy/paste directly than downloading a workbook and opening
it then copy/pasting from that book to yours.


Gord

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

Just was not sure if I could use it or not. But it seems the download
provides an exe file do I just install the code instead?

"Gord Dibben" wrote:

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.

For some reason it did not work.
I followed your instructions and when I ran the macro I got an error 400

"Gord Dibben" wrote:

My instructions are for just copying the code from the site and pasting to a
module.

You also have the option to download a workbook with the code already in it.

I find it easier to copy/paste directly than downloading a workbook and opening
it then copy/pasting from that book to yours.


Gord

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

Just was not sure if I could use it or not. But it seems the download
provides an exe file do I just install the code instead?

"Gord Dibben" wrote:

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.

You missed something.

I followed the exact steps before I posted those instructions and the code ran
fine for me.

Keep trying.


Gord

On Tue, 5 Sep 2006 12:53:02 -0700, capnhud
wrote:

For some reason it did not work.
I followed your instructions and when I ran the macro I got an error 400

"Gord Dibben" wrote:

My instructions are for just copying the code from the site and pasting to a
module.

You also have the option to download a workbook with the code already in it.

I find it easier to copy/paste directly than downloading a workbook and opening
it then copy/pasting from that book to yours.


Gord

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

Just was not sure if I could use it or not. But it seems the download
provides an exe file do I just install the code instead?

"Gord Dibben" wrote:

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.