>How can I use the & macro sub command using a value of THIS.Property....the macro stops processing when it encounters the period after THIS.....Thanks in advance....
Peter,
Macros only work with variables. Copy the property to a variable first and then macro the variable;
lcVar = This.Property
&lcVar