I'm pretty new to VBA programming, but have managed the basics. Now I have been struggeling with a problem today, and try to ask here for some help.

I have a range in a worksheet named "rngInput". This is currently a 85 row, 20 column range containing text and numbers. This range can vary in size in future versions, so I need the code to be flexible regarding the size and location of the array.

What I need is some code to make a backup of the values in this range, stored in an array with VBA. Then I also need some code to restore these values back into the worksheet range.