Thread: Help with VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Leviatano Leviatano is offline
external usenet poster
 
Posts: 16
Default Help with VBA



"Need help with sumif" wrote:

Thanks it works great when you get a chance can you explain me what

Me.cells(3,3) is for?

"Norman Jones" wrote:

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" wrote
in message ...
I need to to this with VBA

A1=randbetween(1,100)