Susan Harkins
ssharkins at gmail.com
Tue Mar 18 12:36:25 CDT 2008
I want to loop through a Range object's properties and list the current setting. I'm getting nowhere, because I can't find a properties collection for the Range object. Of course, I'm thinking in Access VBA terms, so maybe this functionality just doesn't exist in Excel. But, here's what my head wants to do... For Each property in Range.Properties Debug.Print property.Name Debug.Print property.Value Next With the right declarations, this is easy in Access. Susan H.