![]() |
List an object?
Is there a function or easy way to write a function to
list the object properties. For instance if the object was a cell then I would like to list all the properties and values associated with the cell. this is as close as i can get; Function ListObject(objToList As Object) Dim i As Variant 'somehow I'm trying to figure out how to 'loop through each property For Each i In objToList 'I want to print the name and value of the property Debug.Print i(Name) = i(Value) Next i End Function |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com