declare array and fill rows and columns

Hi,

I'm quite new into arrays. I'm lokking for a code that makes it possible to:

- Delare an array (amount of columns is fixed, but amount of rows increase whille looping)
- Write data to the array
- Set Array back to worksheet

Setting back the array to a worksheet is something i know how to do. I red something about that it isn't possible to add rows to an array, but it is possible to add columns. I can use the transpose for that i guess..

Thanks in advance!

Bart

One normally needs to know how many rows you'll need in advance for the array. If you explain what you're actually trying to do we may be able to offer some suggestions:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi,

See workbook

I want to loop through all the rows in sheet "KyleAll". So i fill an array with the data in this sheet, then i loop through the array. If column B = "hassolution" then i want to add this entire row to a new array.

I don't know how many rows there are with "hassolution"..

Regards

Norrie,

Perfect! :-)

Thanks!

Bart