N Norman Jones May 23, 2006 #2 Hi Need help with sumif, Try: '=============>> Private Sub CommandButton1_Click() Me.Range("A1").Formula = "=RandBetween(1,100)" End Sub '<<=============
Hi Need help with sumif, Try: '=============>> Private Sub CommandButton1_Click() Me.Range("A1").Formula = "=RandBetween(1,100)" End Sub '<<=============
G Guest May 23, 2006 #3 Thanks it works great when you get a chance can you explain me what Me.cells(3,3) is for?
N Norman Jones May 23, 2006 #4 Hi Need help with sumif, Thanks it works great when you get a chance can you explain me what Me.cells(3,3) is for? Click to expand... Since the (CommandButton) code is in a worksheet module, Me refers to the worksheet holding the code. Cells(3.3) is equivalent to Range("C3") and was used because you specified it:
Hi Need help with sumif, Thanks it works great when you get a chance can you explain me what Me.cells(3,3) is for? Click to expand... Since the (CommandButton) code is in a worksheet module, Me refers to the worksheet holding the code. Cells(3.3) is equivalent to Range("C3") and was used because you specified it:
L Leviatano Oct 28, 2009 #5 Need help with sumif said: I need to to this with VBA A1=randbetween(1,100) Click to expand...
L Leviatano Oct 28, 2009 #6 Need help with sumif said: Thanks it works great when you get a chance can you explain me what Me.cells(3,3) is for? Click to expand...
Need help with sumif said: Thanks it works great when you get a chance can you explain me what Me.cells(3,3) is for? Click to expand...
L Leviatano Oct 28, 2009 #7 Norman Jones said: Hi Need help with sumif, Try: '=============>> Private Sub CommandButton1_Click() Me.Range("A1").Formula = "=RandBetween(1,100)" End Sub '<<============= Click to expand...
Norman Jones said: Hi Need help with sumif, Try: '=============>> Private Sub CommandButton1_Click() Me.Range("A1").Formula = "=RandBetween(1,100)" End Sub '<<============= Click to expand...
L Leviatano Oct 28, 2009 #8 Norman Jones said: Hi Need help with sumif, Since the (CommandButton) code is in a worksheet module, Me refers to the worksheet holding the code. Cells(3.3) is equivalent to Range("C3") and was used because you specified it: Click to expand...
Norman Jones said: Hi Need help with sumif, Since the (CommandButton) code is in a worksheet module, Me refers to the worksheet holding the code. Cells(3.3) is equivalent to Range("C3") and was used because you specified it: Click to expand...
