Quote Originally Posted by Kenneth Hobson View Post
Private Sub CommandButton1_Click()
  Range("G5,G28,G51").Value = 2
  Range("D16,D39,D62").Value = "C/D"
End Sub
Does the code you provided not allow for a certain number of cells within the range? In other words can I insert 45 cells into each range?