Hi

I want fill a column in my list with multiples of 5 between 5 and 30.
is there any formula which can solve my problem.

thanks

=RANDBETWEEN(1,6)*5
--
Gary''s Student - gsnu200846

=5*RANDBETWEEN(1,6)
and fill it down as necessary!
Regards,
Stefi

€žshaji€� ezt Ã*rta:

Hi

I want fill a column in my list with multiples of 5 between 5 and 30.
is there any formula which can solve my problem.

thanks

Hi,

For constant values that won't change when the worksheet calculates try
this. Right click your sheet tab, view code and paste this in and run it

Sub Fillem()
For Each c In Range("A1:A100")
c.Value = Application.Run("ATPVBAEN.XLA!Randbetween", 1, 6) * 5
Next
End Sub

Mike

"shaji" wrote:

Hi

I want fill a column in my list with multiples of 5 between 5 and 30.
is there any formula which can solve my problem.

thanks