Edit attribute progamatically

[Ed Jobe]

Funtions that accept arguments for filter data require that you pass it in the form of a variant array, i.e. you need to dim a variant and then assign the array to the variant. For some code, check out help example for that select method.

Also, if you are using a wildcard for all names, then that's the same logic as not filtering names at all. You can leave that part off.

[MikeJarosz]

Also, make sure you understand option base. To most people, starting a count at zero is unnatural, but unless you decare otherwise, that is the VBA default.

[Ed Jobe]

Its not that. If you declare a sub with an argument with a variable that is an array, you won't be able to use the argument. You will get a "Can't assign to array error." when you try to set the arg at runtime. Since an array consists of multiple sub elements, you can't just simply say 'this array equals that array'. The only way to assign values to an "existing array" is to specify the index at which to store a value. VBA needs to know what values to put at what index. Therefore, you create a sub that has a variant as an arg. VBA can create then create an new array dynamically at assign time. The only trick is that the sub with such an argument must know how to deal with it or you will get other errors.

[artisteroi]

Its not that. If you declare a sub with an argument with a variable that is an array, you won't be able to use the argument. You will get a "Can't assign to array error." when you try to set the arg at runtime. Since an array consists of multiple sub elements, you can't just simply say 'this array equals that array'. The only way to assign values to an "existing array" is to specify the index at which to store a value. VBA needs to know what values to put at what index. Therefore, you create a sub that has a variant as an arg. VBA can create then create an new array dynamically at assign time. The only trick is that the sub with such an argument must know how to deal with it or you will get other errors.

ummm, ok.

I'm starting to think this might be beyond my comprehension. maybe I need to hire someone else to do code and just go back to the engineering part. Anyone need a job?

[Ed Jobe]

Variables are areas of memory set aside for specific uses. Each type of variable has its own size and structure. So you can only put things in them designed to fit the structure and size restrictions. An array is like a storage cabinet with multiple shelves (storage locations). In order to put something in the cabinet, you have to be specific and tell the loader what shelf to put it on. If you have another cabinet you can't just simply say 'put whatever is in this cabinet in the other cabinet'. You have to be more specific and say 'put what's on shelf 1 in cab A on shelf 1 in cab B' since the shelves in cab B will hold them in any order. But if you have a large empty shed (variant), you can say 'put cab A in the shed'.