Fill string array with column values

Hello,

I wish to declare and fill a string array with worksheet column A values.

* My columns contains strings and there are empty lines between the rows.
* I do not know how many rows there are in column A

How can I do that using VBA ?

Thank you for your help

Try this

Please Login or Register  to view this content.

Hope this helps

Yes, the result in array sq.

Please Login or Register  to view this content.