chriscorpion786
Board Regular
- Joined
- Apr 3, 2011
- Messages
- 108
- Office Version
- 365
- Platform
- Windows
Hi All,
I have 100 rows, and 22 columns. Based on a filtered criteria, the rows are filtered. I would like to read the filtered rows using special cells or any other method into an array.
Then write the array (filtered results) back to a sheet.
What is the best method using auto filter or a loop ? to loop through the rows based on the criteria. Which one is fastest ?
Can you please share the code. The difficult part I'm finding is to resize the filtered rows and read them into an array and then back to the sheet.
Thank you,
Mustafa
I have 100 rows, and 22 columns. Based on a filtered criteria, the rows are filtered. I would like to read the filtered rows using special cells or any other method into an array.
Then write the array (filtered results) back to a sheet.
What is the best method using auto filter or a loop ? to loop through the rows based on the criteria. Which one is fastest ?
Can you please share the code. The difficult part I'm finding is to resize the filtered rows and read them into an array and then back to the sheet.
Thank you,
Mustafa