software

I need to to this with VBA

A1=randbetween(1,100)

Hi Need help with sumif,

Try:

'=============gt;gt;
Private Sub CommandButton1_Click()
Me.Range(quot;A1quot;).Formula = quot;=RandBetween(1,100)quot;
End Sub
'lt;lt;=============---
Regards,
Norman
quot;Need help with sumifquot; gt; wrote
in message ...
gt;I need to to this with VBA
gt;
gt; A1=randbetween(1,100)
Thanks it works great when you get a chance can you explain me what

Me.cells(3,3) is for?

quot;Norman Jonesquot; wrote:

gt; Hi Need help with sumif,
gt;
gt; Try:
gt;
gt; '=============gt;gt;
gt; Private Sub CommandButton1_Click()
gt; Me.Range(quot;A1quot;).Formula = quot;=RandBetween(1,100)quot;
gt; End Sub
gt; 'lt;lt;=============
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;
gt; quot;Need help with sumifquot; gt; wrote
gt; in message ...
gt; gt;I need to to this with VBA
gt; gt;
gt; gt; A1=randbetween(1,100)
gt;
gt;
gt;

Hi Need help with sumif,

gt; Thanks it works great when you get a chance can you explain me what
gt; 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(quot;C3quot;) and was used because you specified
it:

gt;gt; I'm sorry what I meant was Cells(3,3) = randbetween(1,100)---
Regards,
Norman


quot;Need help with sumifquot; wrote:

gt; Thanks it works great when you get a chance can you explain me what
gt;
gt; Me.cells(3,3) is for?
gt;
gt; quot;Norman Jonesquot; wrote:
gt;
gt; gt; Hi Need help with sumif,
gt; gt;
gt; gt; Try:
gt; gt;
gt; gt; '=============gt;gt;
gt; gt; Private Sub CommandButton1_Click()
gt; gt; Me.Range(quot;A1quot;).Formula = quot;=RandBetween(1,100)quot;
gt; gt; End Sub
gt; gt; 'lt;lt;=============
gt; gt;
gt; gt;
gt; gt; ---
gt; gt; Regards,
gt; gt; Norman
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Need help with sumifquot; gt; wrote
gt; gt; in message ...
gt; gt; gt;I need to to this with VBA
gt; gt; gt;
gt; gt; gt; A1=randbetween(1,100)
gt; gt;
gt; gt;
gt; gt;



quot;Need help with sumifquot; wrote:

gt; I need to to this with VBA
gt;
gt; A1=randbetween(1,100)



quot;Norman Jonesquot; wrote:

gt; Hi Need help with sumif,
gt;
gt; Try:
gt;
gt; '=============gt;gt;
gt; Private Sub CommandButton1_Click()
gt; Me.Range(quot;A1quot;).Formula = quot;=RandBetween(1,100)quot;
gt; End Sub
gt; 'lt;lt;=============
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;
gt; quot;Need help with sumifquot; gt; wrote
gt; in message ...
gt; gt;I need to to this with VBA
gt; gt;
gt; gt; A1=randbetween(1,100)
gt;
gt;
gt;



quot;Norman Jonesquot; wrote:

gt; Hi Need help with sumif,
gt;
gt; gt; Thanks it works great when you get a chance can you explain me what
gt; gt; Me.cells(3,3) is for?
gt;
gt; Since the (CommandButton) code is in a worksheet module, Me refers to the
gt; worksheet holding the code.
gt;
gt; Cells(3.3) is equivalent to Range(quot;C3quot;) and was used because you specified
gt; it:
gt;
gt; gt;gt; I'm sorry what I meant was Cells(3,3) = randbetween(1,100)
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;