Generate worksheet with sample data

[dageci]

Hello,

does anyone have a simple vba function to generate worksheet with, for example, 100 columns and 10.000 rows?

[kasan]

Hi,
What kind of data you wish to have in this sample? Numbers?
One way to do this could be create array 100x10000, fill it with random numbers and then return this array to the sheet range.

This one will generate 10x10 sample:

Please Login or Register  to view this content.

[dageci]

Does anyone know the way without the array?

[dageci]

Thank you kasan.

I have changed your code a little:

Please Login or Register  to view this content.