Generate Random numbers across sheets

[grkchakri]

Hi All

I am creating command button to generate numbers from Range("B2 : G26"). The code works well with the active sheet.
I am looking for suggestions on how to generate numbers in other sheets for range ("B2:G26") as well using the same code/ command button.

Please Login or Register  to view this content.

Also i would like while the below line code executes only one set of numbers (example :10 across the range)

Please Login or Register  to view this content.

[davesexcel]

You may have to place the formula in each cell first, then change the ranges into values.

Please Login or Register  to view this content.

[grkchakri]

I am looking for some suggestions if i can generate random numbers through vba across all sheets (example 3_sheets at same range "b2:g26") at once. and also want to understand why the below code only generates a single number.

Please Login or Register  to view this content.

[grkchakri]

Hi All

I was able to generate random numbers all the 4 sheets using one command button using below code. Any other suggestions to simply code.

Please Login or Register  to view this content.