Re: $$Excel-Macros$$ Re: Four options to every question need to be randomized

2014-11-04 Thread Vaibhav Joshi
Thanks for posting. + *I did not do this for you. God is here working through me for you.* On Wed, Nov 5, 2014 at 9:40 AM, Rajnish Malhotra < freeofcosthotels...@gmail.com> wrote: > I got an answer at excelforum and thought I should update the link > http://www.excelforum.com/excel-programmi

$$Excel-Macros$$ Re: Four options to every question need to be randomized

2014-11-04 Thread Rajnish Malhotra
I got an answer at excelforum and thought I should update the link http://www.excelforum.com/excel-programming-vba-macros/1047574-shuffle-four-answers-of-one-question-with-a-condition-and-loop-it.html Thank you Sub test() Dim r As Long Dim CA As String For r = 1 To Cells(Rows.Cou