Random

[pichai]

Hi,
K1:K30000 I HAVE THE NUMBER SUCH AS THIS ... 11254-3 ,12847-7,
4128-6,6247-8...... HOW CAN I HAVE THE VBA CODE USED FOR THE MACRO BUTTOM WHEN IT CLICK . IT WILL RANDOM THE ONLY RANDOM NUMBER SHOW ON THE CELL A1

THANK

[jindon]

1) Stop using all caps.
2) try

Please Login or Register  to view this content.

[pichai]

your best code !!
thank so much
pichai