I am trying to copy different rows of a sheet (not one below the other) and
to paste them in another sheet but I received a message saying: command
cannot be used on multiple selections. Is any way to do it because it takes
too long for a sheet of 7000 rows

If you select entire rows, it should work.

--
Regards,
Tom Ogilvy

"Penny" <Penny @discussions.microsoft.com wrote in message
...
I am trying to copy different rows of a sheet (not one below the other)
and
to paste them in another sheet but I received a message saying: command
cannot be used on multiple selections. Is any way to do it because it
takes
too long for a sheet of 7000 rows

Penny wrote:
I am trying to copy different rows of a sheet (not one below the other) and
to paste them in another sheet but I received a message saying: command
cannot be used on multiple selections. Is any way to do it because it takes
too long for a sheet of 7000 rows

It might be done with a VBA macro if there is a pattern to the rows
you're copying. I.e., is it every other row, every third row? Or, do
the rows you want to copy and paste all have a certain number or text
string in a predictable location? If so, a macro could probably do it.