| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with VBA
I need to to this with VBA
A1=randbetween(1,100) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
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? 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: I'm sorry what I meant was Cells(3,3) = randbetween(1,100) --- Regards, Norman |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
"Need help with sumif" wrote: I need to to this with VBA A1=randbetween(1,100) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
"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) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with VBA
"Norman Jones" wrote: 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? 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: I'm sorry what I meant was Cells(3,3) = randbetween(1,100) --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
