You might think about looping through your range and setting matching rows of your random selection to an array and re-populate that way.
You might think about looping through your range and setting matching rows of your random selection to an array and re-populate that way.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables