Originally Posted by Kenneth Hobson 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?
Private Sub CommandButton1_Click() Range("G5,G28,G51").Value = 2 Range("D16,D39,D62").Value = "C/D" End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks