Re: $$Excel-Macros$$ randomly select non-contiguous cells in a range vba excel

2014-02-15 Thread ashish koul
can you please share sample workbook On Sat, Feb 15, 2014 at 2:15 AM, Pascal Scalpa wrote: > Hello, how to randomly select non-contiguous cells in a range vba excel > > I have a range A1:AC1 and i would like to randomly select 10 cells in it > non contiguous and then each of these cells will be

$$Excel-Macros$$ randomly select non-contiguous cells in a range vba excel

2014-02-14 Thread Pascal Scalpa
Hello, how to randomly select non-contiguous cells in a range vba excel I have a range A1:AC1 and i would like to randomly select 10 cells in it non contiguous and then each of these cells will be merge with the one on its right. Example il R1 was selected at the next step it will be merge with