Would one of you mind showing me what the code would then appear like?
I have xl2002.

(Wild Bill) wrote in message ...
Thanks. Clear and specific :)

On Thu, 21 Aug 2003 04:31:34 -0700, keepitcool
wrote:

Wild Wild Bill...

don't draw your sixshooter on me :)

you need CallByName (as used in chip's code)
but.., you'll find it only in VBA6 (xl2000+)
and... there's NO WAY ELSE.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Wild Bill) wrote:

1. I have racked my brains trying and searched the web and groups for
hours on this. What do I'd like to do is run through a sheet's
properties. Essentially:

Dim prp As Property
For Each prp In Sheets(1).Properties

I've tried all kinds of variations on Sheets(1). Except perhaps the
correct one.
DAO 3.6 is enabled.
Chip's GetInfo disclaims use on XL97.

2. I would like to access a "variable" property in a sub, a la
call MySub("activecell.Font")
sub MySub(prp as Property)
debug.print prp.name
end sub

Obviously all of the code above is faulty, but I hope it illustrates
what I'm trying to achieve. I confess that I am swimming over my
head, being less than an expert on VB(A) objects.