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