Read value from ColA+Current Row into an Array

[kpierce]

This may be a trivial task, but I am hoping someone can help me out.

I need to create an array that contains:
Current Row, Column A Value

I need to read the sheet until no more values are found.
I then need to figure out how to reference the values in the array.

I really apprecaite any help and code samples that can be supplied.



thanks

k

[watersev]

hi kpierce, please check attachment, press Run button