For Each sh In sSheet.Shapes
sh.Left =sh.TopLeftCell.Left
sh.Top =sh.TopLeftCell.Top
sh.Width =sh.TopLeftCell.Width
sh.Height =sh.TopLeftCell.Height
endfor
For Each sh In sSheet.Shapes
sh.Left =sh.TopLeftCell.Left
sh.Top =sh.TopLeftCell.Top
sh.Width =sh.TopLeftCell.Width
sh.Height =sh.TopLeftCell.Height
sh.address=sh.TopLeftCell.Address
endfor