Snap an object to a cell border via macro
Absolute corker! Thanks Greg - you don't know how much that will change my
life!
Regards, Brett
"Greg Wilson" wrote:
Try:
With ActiveSheet.Shapes("Text Box 1")
.Left = Range("A1").Left
.Top = Range("A1").Top
End With
Greg
|