For each set property, print property name and value

[Jaymond Flurrie]

How can I print all the info I have about an object? I mean like for range it could be like

name = "ThisCellRightHere"
address = "$A$1"
value = 15

and so on.

 

[jkpieterse]

You'll have to do it the hard way: you need a list of all properties and run through them.
I have a tool called ObjectLister which enables you to get a list of any object's properties and methods:
www.jkp-ads.com/articles/objectlister.asp