-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sequential numbers
-
Sequential Numbering VBA for Multiple Ranges
Hello All- I've created a gift certificate that I would like a VBA to print sequential numbers in three separate ranges (I1, I12, I23). There are three gift certificates per page each needing it's own number. I found a VBA that will do one range very well - it prompts me with a beginning and...- smurphy208
- Thread
- invoices ranges sequential numbers vba
- Replies: 8
- Forum: Excel Questions
-
N
Convert List Of Sequential Numbers Into Ranges
hey i have a list in the same cell separated by , ex: <colgroup><col width="229"></colgroup><tbody> 1,2,3,4,5,9,22,23,24,25,244,245,246,247,248,249 </tbody> and so on i want it to be converted into 1-5,9,22-25,244-249 any help would be much appreciated.Thanks- nmganey
- Thread
- excel 2016 vba excel arrays ranges sequential numbers
- Replies: 10
- Forum: Excel Questions
-
J
Sequential Formula in VBA
Hello, I have this formula =INDEX('Compliation 1600 Daily'!H3:H243, SMALL(IF(1='Compliation 1600 Daily'!F3:F243, ROW('Compliation 1600 Daily'!F3:F243)-ROW('Compliation 1600 Daily'!F3)+1),ROW('Compliation 1600 Daily'!1:1))) That i would like to be able to copy into a row. However, i would like...- jap7675
- Thread
- excel index small count sequential numbers vba
- Replies: 0
- Forum: Excel Questions
-
J
Several Problems in One - Auto fill formula to cell 'X', with sequential number change in formula. All using VBA.
I have this formula, which does exactly what I want it to, but in a primative way. It searches for numbers that correspond to another sheet, and pulls out corresponding tag names. However it completes row by row. I would like this formula to automatically repeat itself, for the amount of times...- jap7675
- Thread
- repeat formula sequential numbers vba
- Replies: 0
- Forum: Excel Questions
