Tutorial for populating a 100x100 array with a random number between 1 and X

**Darth269** · 04-11-2017, 04:05 AM

Hi there all,

I'm looking to see if anyone can point me towards a tutorial or set of tutorials that would help me create and populate a vba 100x100 array with a random whole number between 1 and X, where X is likely 32 or somewhere near it, but I've not yet finalised.

The answer to this would be lovely, but I think i'd learn more if anyone could guide me.... I've searched a number of tutorials on arrays, and will keep doing so, but being completely new to arrays, it's tough going and I wondered if anyone knows of any particularly good tutorials...

Thanks in advance...

Darth

**zbor** · 04-11-2017, 04:18 AM

Use

Formula:

Please Login or Register  to view this content.

and pull formula to fill all array.

Then copy -> paste as values if you don't wan them to change.

**Darth269** · 04-11-2017, 04:21 AM

Originally Posted by zbor

Use

Formula:

Please Login or Register  to view this content.

and pull formula to fill all array.

Then copy -> paste as values if you don't wan them to change.

Hi there and thanks for the reply... however unless i'm missing something, this doesn't help with a VBA Array... I guess I should have specified, but I thought using the term Array, and posting in the Macro forum would make it clear. I do appreciate the response though, and don't want to sound ungrateful, this just isn't what I'm looking for.

**zbor** · 04-11-2017, 04:27 AM

People often put question in a wrong subforum so it's nice to write desired solution

Here, try this:

Please Login or Register  to view this content.

**bakerman2** · 04-11-2017, 05:16 AM

Create Array in memory and write to worksheet in 1 go.

Please Login or Register  to view this content.

**Darth269** · 04-11-2017, 05:45 AM

Originally Posted by bakerman2

Create Array in memory and write to worksheet in 1 go.

Please Login or Register  to view this content.

Hi there Bakerman2,

thanks for that, I think i've come up with almost what you've written, but i'm getting an error when running, can you spot where I've gone wrong?

Please Login or Register  to view this content.

runtimeerr.png

**Darth269** · 04-11-2017, 05:49 AM

Oh crap... I think i've figured it, though I don't understand why...

I changed "Dim MapArray() As Byte" to Integer.... the code now works.

**bakerman2** · 04-11-2017, 06:39 AM

You're welcome and thanks for rep+.

Tutorial for populating a 100x100 array with a random number between 1 and X

LinkBack

Thread Tools

Rate This Thread

Display

Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Re: Tutorial for populating a 100x100 array with a random number between 1 and X

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Random numbers but each number not eqully random.

IF statement to evaluate result of random number generator to generate next random number

[SOLVED] Generate random 6-16-byte random hexadecimal number

A Good Array Formula Tutorial Anywhere?

Create a random array contain a fixed number

[SOLVED] array formula tutorial

How do I find random number in list of random alpha? (Position is.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions