Paste Small Range into Big Range
 

Howdy,

I have tow ranges, smallRange and bigRange. Both are dynamically named, 1
column wide and smallRange is always <= bigRange. I want to copy the
smallRange and paste it into bigRange, but when I do, the smallRange values
repeat until the bigRange is full.

For example if smallRange is numbered 1-10 and bigRange was 100 rows high,
the result of:
smallRange.copy Destination:=bigRange
gives 1-10, 10 times. IOW, the bigRange is filled with several iterations
of smallRange.

Any suggestions on how to prevent this?

Regards,
Tim

Paste Small Range into Big Range
 

Maybe you want this:

Range("smallRange").Copy Range("bigRange").Cells(1)

RBS

"tim" wrote in message
...
Howdy,

I have tow ranges, smallRange and bigRange. Both are dynamically named, 1
column wide and smallRange is always <= bigRange. I want to copy the
smallRange and paste it into bigRange, but when I do, the smallRange
values
repeat until the bigRange is full.

For example if smallRange is numbered 1-10 and bigRange was 100 rows high,
the result of:
smallRange.copy Destination:=bigRange
gives 1-10, 10 times. IOW, the bigRange is filled with several iterations
of smallRange.

Any suggestions on how to prevent this?

Regards,
Tim

Paste Small Range into Big Range
 

RB,

Thanks for the tip, appears to do the trick.

Must have been too late, or early, depneding on your perspective...

Regards,
Tim

"RB Smissaert" wrote:

Maybe you want this:

Range("smallRange").Copy Range("bigRange").Cells(1)

RBS

"tim" wrote in message
...
Howdy,

I have tow ranges, smallRange and bigRange. Both are dynamically named, 1
column wide and smallRange is always <= bigRange. I want to copy the
smallRange and paste it into bigRange, but when I do, the smallRange
values
repeat until the bigRange is full.

For example if smallRange is numbered 1-10 and bigRange was 100 rows high,
the result of:
smallRange.copy Destination:=bigRange
gives 1-10, 10 times. IOW, the bigRange is filled with several iterations
of smallRange.

Any suggestions on how to prevent this?

Regards,
Tim