Logic problem with Range values

[JohnSidney]

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:

Please Login or Register  to view this content.

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

[protonLeah]

1. You really need to post the entire code.
2. You used the word "worksheet" in your post. Did you mean workbook?
3. Also, you seem to be trying to close the workbook from which the macro is running prior to opening your destination book. Er...no, no. You close the book/file containing the macro, the macro must stop; therefore, the message from the clipboard.
4.

strCellAddress = rCell.Address
strCellAddress = rCell.Value

Note that you load the string variable with a cell address, then immediately replace it with the value of the cell. What was your intent here?

[Leith Ross]

Hello ,

In addition to Ben's suggestions, please change your title. Your title does not accurately reflect your question. Thread titles should be in a format suitable for database searches. I would suggest "How to copy range values from one worksheet to another"