Hello
I need a macro that will sort cells randomly in each column A1:A2323, column B1:B2323 ...column CZ1:CZ2323 (104 columns).
Unfortunately I don't have much experience using VBA so any assistance you could provide would be really appreciated.
Kind Regards
Last edited by MORACH87; 11-08-2013 at 03:08 AM.
See if this helps. Please try on a small set of data first.
Please Login or Register to view this content.
I just tested a little with 2100 rows x 100 columns of data and the results wasn't satisfactory to me. It didn't look random enough.
Made some amendments:
Please Login or Register to view this content.
Try this
Please Login or Register to view this content.
Last edited by jindon; 11-08-2013 at 08:14 AM.
Another:
Please Login or Register to view this content.
Hi
Thank you very much for your help and for the quick response. It really means a lot to me.
Millz I tested your final version of the code and it works great.
Have a wonderful day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks