Random CellsValues from a range

Good Morning all,
sorry to bother,
I need to pick x(could be any nr between 1 and 6) cells values
from a range like("B2:G50") where values are from 1 to 50, the numbers are random and not in order
(could be duplicates in that range or some values could not exist in range).
I dont need random exactly from 1 to 50 because not work for me.
So, how to extract, x cells values from that range no duplicates in result and paste to
let say from "U3:Y3".
Must be a macro.
thank you

When you say "no duplicates" ... do you mean no cell selection duplicated? Because you've said there are values that are duplicated in the range, and so random cells could possibly choose 2 cells that have the same value, and so would look like duplicates.

no duplicates in result

Thank you very much for you answer
but it is not what i am looking for,maybe it is little hard to understand what i need
for 1 to 50 random nr like i said i now how to doit:

Please Login or Register  to view this content.

But Thank you very much for you time
I sorted with couples of procedure what i want to do
Thank you very much

your code does not appear to filter out duplicates whereas @kvrsinivasamurthy's does

thank you very much