Random number generator

[sweetjonnycrash]

I have this vba to generate random numbers 0-9..my problem is that it will generate in a column and I would like it to also generate random numbers in the row .
any help would be greatly appreciated.

Please Login or Register  to view this content.

[osusuki]

This is probably too simple, but won't your code write a row instead of a column if you just switch parameters in the Offset method, like this:

Please Login or Register  to view this content.

[sweetjonnycrash]

That does work but I am trying to have the numbers generated across not be in the same order as the ones up and down..and work off the same form button. Sorry I didn't explain exactly what I wanted.