Command Button To Reset Values

**Strugggler** · 02-18-2009, 09:39 PM

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?

**mewingkitty** · 02-18-2009, 10:04 PM

You could enter them individually, but I don't think it'll allow you to declare a range that large. You could just do like 5 on each line though.

**Strugggler** · 02-18-2009, 10:54 PM

Thanks sooooooo much! U R great!

Re: Command Button To Reset Values