Basic Questions On How To Display Data

As you write code directly, go ahead and break the habit of selecting cells/ranges prior to manipulating them. It's unnecessary and slows down your code. I would write your code above in one line:

Please Login or Register  to view this content.

Formatting doesn't matter, it's aesthetics. Properly indenting makes code easier to read, shows where new "sections of logic" start and stop. Ease of reading is so critical, this forum even requires posted code be in [ code ] tags for that very reason.

As for building an array in VBA memory, I've never done that specific thing, but I can't imagine it's difficult writing the array into a range like above. Something like:

Please Login or Register  to view this content.

As indicated, I haven't used arrays in memory in that manner, but if it were my first time, I would try using it the same way I would have used a Range to see if it worked...researched from there...something like:

Please Login or Register  to view this content.

I might have gotten lucky...

If I build an array in VBA, how do I display that on the worksheet? It will be 100 x 3 in size.

Please Login or Register  to view this content.

Hehe, awesome, SHG, my guess floweth nowhere. Next thing for me to spend time getting to know...