G
Guest
I need to to this with VBA
A1=randbetween(1,100)
A1=randbetween(1,100)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Norman Jones
Hi Need help with sumif,
Try:
'=============>>
Private Sub CommandButton1_Click()
Me.Range("A1").Formula = "=RandBetween(1,100)"
End Sub
'<<=============
Try:
'=============>>
Private Sub CommandButton1_Click()
Me.Range("A1").Formula = "=RandBetween(1,100)"
End Sub
'<<=============
G
Guest
Thanks it works great when you get a chance can you explain me what
Me.cells(3,3) is for?
Me.cells(3,3) is for?
N
Norman Jones
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:
Thanks it works great when you get a chance can you explain me what
Me.cells(3,3) is for?
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
Need help with sumif said:I need to to this with VBA
A1=randbetween(1,100)
L
Leviatano
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?
L
Leviatano
Norman Jones said:Hi Need help with sumif,
Try:
'=============>>
Private Sub CommandButton1_Click()
Me.Range("A1").Formula = "=RandBetween(1,100)"
End Sub
'<<=============
L
Leviatano
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: