I have the below code that cuts and pastes a Group of shapes to a new location.
What is frustrating me is that I can’t find the way to JUST use “Center on Column:AS”, instead of resort to using
Left = Destrng.Left – 35
This is Sub code
What is frustrating me is that I can’t find the way to JUST use “Center on Column:AS”, instead of resort to using
Left = Destrng.Left – 35
This is Sub code
VBA Code:
Public Sub MoveShapeToLrwD2()
Dim sht As Worksheet
Dim rng As Range
Dim FrwD As Long
Dim LrwD As Long
Dim Destrng As Range
Dim shp As Shape
Set sht = ThisWorkbook.ActiveSheet
Set rng = Range("AK:AK").Find(What:="Paid To", LookIn:=xlValues, LookAt:=xlWhole)
FrwD = rng.Row
LrwD = sht.Cells(sht.Rows.Count, "AT").End(xlUp).Row + 3
Set Destrng = Range("AS" & LrwD)
Set shp = ActiveSheet.Shapes("Group 1")
ActiveSheet.Shapes.Range("Group 1").Select
With shp
.Left = Destrng.Left - 35
.Top = Destrng.Top
End With
Range("AT" & FrwD).Select 'Effectivly DE-SELECTS Group 1
End Sub