View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default copy non-consecutive rows

Ross

Excel is pasting rows 2,3,6,8:12,15,19 into A1:A10 consecutively in the target
workbook.

It won't paste those rows into 2,3,6,8:12,15,19 with blank rows included.


Gord Dibben MS Excel MVP


On Thu, 14 Sep 2006 17:10:02 -0700, Ross wrote:

i am copying non-conseutive rows from 1 workbook to paste into another
workbook.
when i paste excel is pasting the enitire range of rows instead of only
the
selected rows.
ex: i select rows 2,3,6,8-12,15 & 19 by holding control and clicking the
row #
then i press control+c to copy
then i select cell A1 in a differnt workbook
then i press control+v to paste
excel pastes rows 2-10
can anyone explain what i am doing wrong?