RobBroekhuis
Technical User
Here's a general VB/VBA question that I've wondered about: is there any way to copy all of the properties of one complex object to those of another object of the same type? For example, if I have a Characters object in variable MyCharacters, and I want to use it as an Excel axistitle, VBA won't allow the assignment:
activechart.axes(xlCategory,xlPrimary).axistitle=characters=MyCharacters
Is there a generic way (without explicitly spelling out all the properties) to make this work?
Rob
![[flowerface] [flowerface] [flowerface]](/data/assets/smilies/flowerface.gif)
activechart.axes(xlCategory,xlPrimary).axistitle=characters=MyCharacters
Is there a generic way (without explicitly spelling out all the properties) to make this work?
Rob
![[flowerface] [flowerface] [flowerface]](/data/assets/smilies/flowerface.gif)