create a autonumber using macro

[shilpz]

hello

is there any way that i can create a macro that when clicked will make a 4 digit random number on the cell selected

thanks in advance

[VBA Noob]

Maybe

This code calls the function

Please Login or Register  to view this content.

Here's the function

Please Login or Register  to view this content.

VBA Noob

[sweep]

Hi,

Yes there is

Please Login or Register  to view this content.