Fill a column randomly with 5 & 10

S

shaji

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
 
M

Mike H

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
 
Top