I ran your module and it worked.
The values in the testing cells are all at 100 - ah...but the value is being transferred to the cell using a formula - could that be a problem?

I tried the module changing J28 to K28 with a value of 100 and without a formula. It should have printed the array associated with K28 but nothing happened.

Could it be that I am not setting up the macro to the button properly?
Actually when I use the RUN button at the top right of the MACRO window there is still no action.
Any suggestions?