VBA: how to reutilise a stored range

[Nelson78]

Hello everybody.

At the beginning of a macro, I've stored a range in variable rng and then I've deleted it from sheet1.
At the end, I've to "paste" it in another position, starting from row z of column A.

How can I manage this job?


ps. my unsuccessful attempt:

rng.Insert (sheet1.Cells(z, 1))

 

[KennyGreens]

Hi there, do you mind posting more of the code? I'm a bit confused why you would need to copy/store the value at the beginning and wait until the end to paste it back in.

 

[Nelson78]

Hi there, do you mind posting more of the code? I'm a bit confused why you would need to copy/store the value at the beginning and wait until the end to paste it back in.

It's too long to explain why I'm in this situation.

In my opinion, now it is important to find a way to unblock this empasse.

https://imgur.com/a/AUlVQFU

 

[shg]

  Sheet1.Cells(z, 1).Resize(UBound(rng, 1), UBound(rng, 2)).Value2 = rng

 

[Nelson78]

  Sheet1.Cells(z, 1).Resize(UBound(rng, 1), UBound(rng, 2)).Value2 = rng

Exactly.

Thank you.