auto fill help needed

  • Thread starter Thread starter gotzoom
  • Start date Start date
G

gotzoom

I need to generate a sequential number list, but I need it to skip every
13th number. I am starting with # 2343
 
k = 1
for i = 2343 to 5000
if (i-2342) mod 13 <> 0 then
cells(k,1) = i
k = k + 1
End If
Next
 
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

using auto fill, but need to skip every 13th number 3
Auto fill not working 2
Listview Control on same page as form 1
Excel Sequential Numbering System 0
Macro for sequential numbering 8
Concatenate Date and Number field for Append Query 0
Auto numbering 1
Passwords 2

Back
Top