I'm hoping that someone can help me out. The Range statement below has an issue with the right hand side of the equal sign. If I leave out the "& i", the information in the first text box is copied into all of the cells. However, I want to copy info from multiple text boxes. Does anyone see what I'm doing wrong?
Private Sub Save_Click() 'Transfers all values from Userform to Excel sheet For i = 1 To 10 Range("PWTitle" & i).Value = ProgramWork.PWTitle & i.Text Next i End Sub