Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copying complex objects

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top