Thread: [Solved] Create a sequence of numbers using a formula
View Single Post
 
Old 03-17-2018, 10:56 AM
14spar15 14spar15 is offline Windows XP Office 2000
Advanced Beginner
  
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default
What I’m wanting in C1 is it to start with A1 and end with B1 and everything in between values (in whole numbers). I don’t mind using =ROW(INDIRECT(A1&":"&B1)) but I need to do this in a macro. If A1=5 and B1=8 and the macro in run C1 = 5 6 7 8. If A1=11 and B1=13 and the macro is run C1=11 12 13. I don’t mind the fact that the numbers were separated by “:” as I can substitute those out.