Copy values from Excel Range to VBA array.

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.

Thank You, this works fine.
This was not supposed to be a long time backup, as I know I can't do this way. This was actualy a part of trying to make a workaround for the Undo stack beeing wiped out when I execute some VBA code to update cell formatting.

I now experienced somthing new. This first code, which I made with help from you actually does not flush the Undo stack:

Public Sub MakeUndo()
    Dim myArray As Variant
    myArray = Range("rngInput").Value
    Worksheets(3).Range(Worksheets(1).Range("rngInput").Address).Value = myArray
End Sub

But this code gives med the same result, but flushes the Undu stack:

Public Sub MakeUndo()
    Range("rngInput").Copy
    Worksheets(3).Range(Worksheets(1).Range("rngInput").Address).PasteSpecial xlPasteValues
    Application.CutCopyMode = False
End Sub

Both codes makes a copy of the Values in "rngInput" in Sheet1 and put these values in the same cells in Sheet3. The Sub is run from a Worksheet_Change sub in the Sheet1 Code.

Both subs make changes to cells in the Workbook, but the first one does not flush the Undo stack. Do you know why ? I tought all changes to cells in the Workbook with VBA would flush the Undo stack.