The "trick" to this is to make sure that the selected area will *exactly*
contain the cell *configuration* that is to be copied.
For example,
Try copying A1:A3 to D1:G11,
Select A1 to A3,
Right click in this selection and choose "Copy".
Click in D1 and drag the *cell* (not fill handle) to G11 to select that
range.
Right click in that selection, and choose "Paste".
You'll see that you *only* get D1 to D3 filled.
NOW ... start over again, but select D1 to G12, and when you paste, the
*entire* range will be filled, since the 3 cell "original" will exactly fill
the target range.
The same holds true for columns.
A1:C1 will require a target range where the columns are evenly divisible by
3.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
message
Any tips on how to easily copy, say 3 cells, to say 20,000 more without
painting till your arm falls off?
