Re: Help with VBA

Giganews Newsgroups
Subject: Re: Help with VBA
Posted by:  Norman Jones (normanjon…@whereforartthou.com)
Date: Tue, 23 May 2006

Hi Need help with sumif,

Try:

'=============>>
Private Sub CommandButton1_Click()
    Me.Range("A1").Formula = "=RandBetween(1,100)"
End Sub
'<<=============

---
Regards,
Norman

"Need help with sumif" <Needhelpwithsum…@discussions.microsoft.com> wrote
in message news:39E32CAE-76B8-4DE2-ACCA-C8D826510A…@microsoft.com...
>I need to to this with VBA
>
> A1=randbetween(1,100)

Replies

In response to

Help with VBA posted by Need help with sumif on Mon, 22 May 2006