Hi all

In VBA/Excel is there any way I can dynamically refer to property
names. By this I mean that I want to pass a property name as a
parameter e,g,

sub aSub (aCell as Range, aVal as Variant, prop as ???)

....
aCell.prop = aVal ' or some such

....
end sub

so the input parameter "prop" could be "value" or "formula" or
whatever.

Many thanks

Tone