"Text boxes" are graphical objects, not data apparently. This VBA code is supposed to loop over the boxes and convert it to cells. I really don't do much VBA, so good luck. BTW what ever process was used to generate that data should probably reconsider the use of these boxes. Option Explicit Sub test()     Dim r As Long     Dim TxtBox As TextBox     r = 1 'start in Row 1         For Each TxtBox In ActiveSheet.TextBoxes         Cells(r, "A").Value = TxtBox.Text         TxtBox.Delete         r = r + 1     Next     End Sub ... View more