Create a worksheet cell A1. Set shape as the desired shape. · I save as a picture of the shape. · Then I clear the saved picture using VBA Sub WritePicture(Byre shape As Object, By Val data As String()) shape. Data = data End Sub To clear a saved picture in VBA click File|Clear Picture.