Creating an Array to output titles(text)

Hi, i am trying to create an Array that will print the stock number as a title on row A. e.g. "Stock 1" in A2 "Stock 2" in A3...etc

here is what i have attempted:

Please Login or Register  to view this content.

You don't need an array to do that, you can go:

Please Login or Register  to view this content.

If you do want to use an array, since the array contains text you need to dim it as a string, not a double.
Also:

Please Login or Register  to view this content.

makes the tenth member of the array change each time. To have each the number of array correspond to the Stock number, you'd want:

Please Login or Register  to view this content.

Don't forget array's first number starts at zero. To make it 1, put

Please Login or Register  to view this content.

At the top of the module.

Hope that helps