Copying Range Of Numbers Deletes Previously Copied Numbers In Column

I posted a similar post before, but the script had a lot of irrelevant code. Ive simplified the code for readability. Also if its still not easy to understand, instead of not replying let me know & i'll post a simpler version.

Basically I need to copy a range of numbers from an array to different cell positions, but it deletes previous copied numbers in that column. ie., copy 1,2,3,4 stored in an array to Range("F37:F52").

Im guessing I need to resize the array to match the number of values inside it. Ie., 4. But I dont know how to resize it, as I'm new to arrays.

The line causing the problem is on line 100 : Range(CLabelStartPositionx & ":" & CTotalEndPosition) = Array2

Thanks.,

Please Login or Register  to view this content.

what does the error message say? this code of yours:

Please Login or Register  to view this content.

I've seen done many times, however I it doesn't make sense that excel would let you throw an entire array's matrix of values into an actual range. it doesn't make any sense to me whatsoever. are you sure you can do that? furthermore, I have seen this done many times too:

Please Login or Register  to view this content.

with a ":" in between starting range and ending range. I'm not even sure if that is valid code. but i can't tell you for sure.

there is an issue with the forum software. uploads are getting corrupted or something. the tech team is trying to fix it. I can't look at your file. upload it to google cloud, share it publicly, and post the link here.

https://drive.google.com/

if logged in:

https://drive.google.com/drive/my-drive

you're a genius max, you can do that.

I've uploaded the file to :

https://drive.google.com/file/d/1lLB...ew?usp=sharing

ok, so you posted the code that was in the MODULE, not behind the sheet. do any of these images help? do you see what I did here for you?

Ah, I uploaded the wrong sheet, one sec ill upload the correct, my bad ...

ummmmmmmmmmm

Try https://drive.google.com/file/d/1TUi...ew?usp=sharing

below images:

1) 1st ITERATION THROUGH ''J'' => result after running the script once with no breakpoints.
2) 1st ITERATION THROUGH ''J'' => vals of vars CLabelStartPositionx and CTotalEndPosition at time of insertion from array2.
3) 1st ITERATION THROUGH ''J'' => the result of the offending line of code.
4) 1st ITERATION THROUGH ''J'' => the reason behind image #3's error-oriented output.

below images:

1) 2nd ITERATION THROUGH ''J'' => vals of vars CLabelStartPositionx and CTotalEndPosition at time of insertion from array2.
2) 2nd ITERATION THROUGH ''J'' => the result of the offending line of code.
3) 2nd ITERATION THROUGH ''J'' => the reason behind image #3's error-oriented output.
4) 1st ITERATION THROUGH ''J'' => Array1's values received into the matrix.
5) 1st ITERATION THROUGH ''J'' => Array1's redimensionalization results.

Hi,
Thanks for taking the time, how do I fix it? Im guessing its because of the size of the array, how do i resize the array, so it doesnt overwrite the values?

you responded quickly. did you even look at what I did?

what's the goal again? your first post isn't detailed enough

Yes, I looked at what you did. The amount of cells to copy exceeds 4, so it inserts blank cells. I've tried setting the value to match the number of cells to copy but it still inserts blanks, which is why posted on the forum.

yes that's true Max, but have you thoroughly looked at your code line by line? a lot of it doesn't make sense, my man. you are throwing the entire 8000+ (times 2) cells into the array at the beginning and then your doing something else later on that's completely different. is that not correct?

It doesnt copy the entire range times 2, it resizes array2 to match the size of array1 ...

Array1 = Range("a1:B8660").Value
ReDim Array2(1 To UBound(Array1), 1 To UBound(Array1, 2))

I've fixed the code. Thanks for taking the time, thanks!

good deal. hopefully what I did allowed you to gain insight. and I did NOT say it copies the range times 2. I said this:

you are throwing the entire 8000+ (times 2) cells into the array at the beginning and then your doing something else later on that's completely different.

have a good one.

What did you mean by times 2 then ...