copying complex objects

[RobBroekhuis]

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