oObject.P1 = 23 oObject.P2 = 63 oObject.P3 = 93Now we want to change these values in a for/next loop.
for i = 1 to 10 objectproperty = "oObject.P" + transform(i) &objectproperty = somevariable nextThe macro sub doesn't work in this case. I suppose because its on the wrong side of the equasion.