Hi everyone !
Can someody help me generate a sequence of numbers like
0
1
2 2
3 3 3
4 4 4 4
till 200
in excel with the help of a macro ??
My code is like this :
Thank you !Please Login or Register to view this content.
Hi everyone !
Can someody help me generate a sequence of numbers like
0
1
2 2
3 3 3
4 4 4 4
till 200
in excel with the help of a macro ??
My code is like this :
Thank you !Please Login or Register to view this content.
Last edited by excelvb; 04-06-2011 at 06:20 AM.
Perhps this
Please Login or Register to view this content.
regards
johnjohns
When you are not sure where to go, every road takes you there!
To generate 200 unique random numbers:
Please Login or Register to view this content.
Yes, this is exactly what i wanted. We are almost there ! Can we display the result cell by cell instead of one cell ?
My code now looks like this :
Thanks !Please Login or Register to view this content.
Please Login or Register to view this content.
Perhaps this too
Please Login or Register to view this content.
@johnjohns
Avoid Select & Activate in VBA (unnecessary)
I wouldn't call that random.
Neither would I.
Thank you so much for your help guys ! It's working perfectly !
Even a one-liner suffices:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks