[dba-Tech] Another Excel question

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. 


More information about the dba-Tech mailing list