How to use a Public variant

I want to save a range of numbers so that the range can then be cleared for new values or the old ones can be recovered and put back into the range. I have tried the following code to do this

Please Login or Register  to view this content.

This fails at the first step because the variant is not recognized. Where have I gone wrong?
In the attached sheet the named range OHLabels_Table is V11:X55
If I Dim ArPercent in the 1sr Sub It accepts the values in the table but I cant figure out how to use it in sub2

Hi there,

I'm using Excel 2016.

In the workbook you posted, I clicked on the "Save Changes" button, manually cleared all of the values from Columns V and X, and then clicked on the "Restore" button - all values were restored.

It's difficult to understand exactly what you mean when you say:

because the variant is not recognized

What sort of error message is being generated?

Regards,

Greg M

I am also not getting any errors in 365.

Sorry about the delay in coming ack to you and thanks for your interest.
What happens when I try to run the SAVE CHANGES button is nothing, there are no error messages.
When I step the code each line is visited but nothing happens. The Locals window has no record of the Sub or the variant.
I am not sure if a Public variable would show in the locals window.
I hope this might give clue as to what might be happening.
I am running 365
John

Hi Osprey, what I meant when I said when I wasn't getting any errors, I meant the macros functioned properly and did the job you asked them to do.

PrizeGotti
I took your first post to mean that.
I seem to have solved the problem by creating subs to do the work and using the button_Click code to call them. The public variant then works as wanted. The watch screen showed me that it would work.
John

Hi John, I'm really confused that you had to do this when it worked fine for myself with the original code in the button events.