Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy range and paste into every 3rd cell of new range | New Users to Excel | |||
Use criteria for values in range for small function | Excel Worksheet Functions | |||
to group in small range, and count | Excel Discussion (Misc queries) | |||
Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
range select not working with small sets | Excel Programming |