Hi,

I'm having problems yet again. New to this. Here's what I'm trying to achieve:

1. Open a worksheet - OK
2. Get the range of values - OK
3. Copy the values to a two dim array - not sure I want to do this anymore but oh well
4. Close the worksheet - OK
5. Open another existing work sheet - OK
6. Insert the range into the new workseet - herewith lies my problem.

I can't insert the values over top because I want to take the existing values and accumulate the new ones. Much like the paste special -> Numbers -> Add

I initially tried (in step 2) to copy the text to the clipboard. However, when I close the sheet I get 'you have a large amount of data' message and it halts the script.

I then tried putting it in the 2 dim array. This is not feasible because I really need the Address of the cells as well. Also, UBound and LBound gave me a compile error. In the second sheet, I want to be able to achieve along the lines of:

For Each rCell In Range(strCellRange)
   strCellAddress = rCell.Address
   strCellAddress = rCell.Value
.
.
The only way I can do the above is if I set the range values on the second sheet which is not an option because I need to retain the values. I also tried setting the clipboard once I opened the second sheet using Range(strCellRange).Value as the value but the compiler through a wobbler.

Any help would be GREATLY appreciated!!

Cheers,
JOhn