• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change the position of the questions in a random way

The post 12 file did not change it. Based on what I recommended here, I had to make those changes.

If there are automatic translators, I do not see the limitation of the languages, it only remains to see the will of each person.

The macro works, although with the addition that I placed.
I have it more advanced, when I have finished the app I will try with the students and with a group of teachers to see if there is some pedogogic research.
If here I am getting ready to write and publish I want to ask you to accept being part of the people included in the document.
I hope to you it is possible
Maybe it's something small, but it might be very significant for many
 

As I yet wrote, post #12 is a bad sample 'cause of different layouts
between before & after worksheets ! ...
I can do nothing without a clean workbook without same worksheets layout.
​
 
Visor said:
According to your explanation the fill color can not be moved
Click to expand...
Wrong ! As yet explained just using Range.Copy method ...
The issue was different colors layout between before & after worksheets
without any logic neither any explanation !

As it is very not difficult to post a before workbook respecting real layout
and an after workbook respecting same layout ...
​
 
"Wrong ! As yet explained just using Range.Copy method .."
Yes, but There is not other solution that I have, Range.copy method strategy I dont understand how
 
SourceRange.Copy DestinationRange : this method is valuable only
to keep cells formatting or for VBA beginners ...
Source is data in firsts columns, destination for example is empty columns.
Once shuffle process is achieved, move destination to source
via Range.Cut. Shuffle logic is same than my previous demonstration ...
​
 
You must log in or register to reply here.
Back
Top