I created a dialogue box with 3 option buttons in order to change between result and answers target, but there are wrong array results after code. Why and how to solve it? thanks
Please Login or Register to view this content.
I created a dialogue box with 3 option buttons in order to change between result and answers target, but there are wrong array results after code. Why and how to solve it? thanks
Please Login or Register to view this content.
please post the full spreadsheet.
After I tried more test, I can solve the problem which is change Range("result") = Range("ans_A") to Range("range").Formula = "=ans_A". Now the Range("result") is variable and can be done for array results during run data table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks