Can't fill array with data

Please Login or Register  to view this content.

After the line "Firstbook. activate", I am trying to loop through the data in an array. As I test this, Sales equals "J", which it should and Process equals "J" which it should not. The other "removed" statements all come up with "J" as well.

I would like to load Sales, Process, Designation, Diameter, and Quantity with the data stored in the array. Maybe my array is too big and should only be one row tall?

The problem area is in red though anything before it that should be cleaned up or done in some other fashion, you can let me know.

Any help is always appreciated!

Originally Posted by protonLeah

Please see the comments included below:

Please Login or Register  to view this content.

Thank you very much for the commenting. I don't know this stuff very well at all and this will help a lot!

I was told (somewhere, sometime) that I would learn more if I left option explicit and option base 1 out of things. Harder in the beginning, but better off in the end. I will be changing those numbers for a base of zero.

I had figured out this one

Please Login or Register  to view this content.

but not the initial one. Probably because it is just checking for data or not.

Trying to dimension all the sheets on one line - thought it could be done that way and it explains a few other things I haven't asked!

As for the array being empty... well, I know. How do I fill it with the data from that range? What is it that I'm not doing or too stupid to remember? I have a hard time understanding things in the beginning, but, once I get it, I will have it like a bulldog!