Thread: Snap an object to a cell border via macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Greg Wilson Greg Wilson is offline
external usenet poster
  
Posts: 747
Default Snap an object to a cell border via macro
Try:

With ActiveSheet.Shapes("Text Box 1")
.Left = Range("A1").Left
.Top = Range("A1").Top
End With

Greg
Reply With QuoteReply With Quote