Is it possible to reference layers or groups by their names instead of their index using VBA? If so, what is the sytax? I know you can do it in Extendscript, but I'm not finding info for VBA.
My method has been to copy and paste and then change attributes of the code to see the cause and effect. From that I build upon. It’s hard to just type it and find out what’s wrong if I don’t know the final result first.
But you’re right, doing is always the best way to learn. On a side note, I agree with you that Excel’s object browser is a huge help and easy to work with.