Fill a column randomly with 5 & 10

  • Thread starter Thread starter shaji
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignoring non-filled formulas in average 6
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Subtracting multiple columns from another column 3
GROWTH formula 6
Macro to add numbers in a text string 5
Auto Fill a column 3
Conditional formatting 3
Conditional Format, Color Scale adjacent cells 3

Back
Top