prabha_friend
Board Regular
- Joined
- Jun 28, 2011
- Messages
- 95
Code:
Sub mac2()
Dim Temp() As Variant
With ActiveSheet.Shapes(1)
If Not Not Temp Then ReDim Temp(UBound(Temp) + 1) Else ReDim Temp(0)
Temp(UBound(Temp)) = Array("Top", "Left", "Height", "Width")
For Each element In Temp(UBound(Temp))
.Properties(element) = 100
'.Top = 100
Next element
End With
End Sub
Possible?