Recent content by Koisti

Ok, so how would I put them into the 2nd array in random order?

I have an array called NEWLIST() which can vary in size depending on how many names are in the list. I would like to pick each name only once in a random order untill all of the names have been picked. Can any one help me with this?

Sometimes the orders I deal with have a comment attached to them which can run very long once and a while. Is there a way to have vb check if the length of the comment exceeds a certain amount of characters and if so, then cut the rest off of the end and move them to the cell below?

I have asked about this before, but the answer I got didn't fit what I need exactly, so I will reword the question. I use code to sort out orders in excel. Here is what the first 2 columns look like. Order# Cust. # 9 W063868 9 W063868 9 W063868 10 W065372 10...

I have setup some code to sort out information on orders to be printed out. Sometimes these orders only take up two lines and other times they may take up to 5 or 6 lines. The first column always has the order number, so if there ends up being four lines for the order, the first cell on each...