Hi,
So the following questions are for clarity, as I'm trying to learn VBA to build some tools but need clarity on some syntax/rules. If you have the answers or can point me to clear and unambiguous resources, I will be extremely grateful
1. Filling/Printing the Array: What are the exact rules for Filling with a Loop vs. filling with Range
i.e. Array(9, 9) = .Range("A1:A10") vs. 2 Nested FOr Next loops as an example.
There seems to be some constraints against manipulating the data loaded as a range but I can't get a for sure answer.
2. Selecting Data from an Based on Criteria:
I don't yet have full grasp on arrays, and I'm trying to learn (no prior programming experience), so while I understand collections can provide some flexibility, I would like to understand Arrays a little better before moving to the next topic.
That said, I am using a combination of Named ranges/Arrayformulas/my poor attempts at VBA. Ultimately I'm trying to learn how to load a sheet of data into an array and then select data based on Criteria.
i.e. array(0 to 200, 0 to 150) = Range("A1:ET200") or = [BlueBell] and then I'd like to select everything from Column 2 that meets some criteria *without using the autofilter method. The way I am considering now involves selecting that loading an array operation in a wksheet formula into an array and then finding a way to remove blanks or FALSE.
I have attached a workbook, of a tool I'm tinkering around with to have reference data if this helps
Thanks for any help.
Bookmarks