Create a sequence of numbers using a formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Create a sequence of numbers using a formula

FAQ

Thread Tools

Display Modes

03-17-2018, 10:56 AM

14spar15

Windows XP Create a sequence of numbers using a formula

Office 2000

Competent Performer

Join Date: Mar 2011

Posts: 100

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sequence numbers after each print	MauricioPillon	Excel	0	02-15-2018 08:11 AM
Wildcards - Sequence of Numbers at the Beginning of Each Paragraph	qubie	Word	1	11-30-2017 02:03 PM
How to assign numbers to letters and then create a formula to add them together for a rota	Mskapri	Excel	6	04-01-2017 03:05 PM
Need Help Deleting Numbers in Hour Format and Numbers in Sequence	rsrasc	Word VBA	1	10-12-2016 02:49 PM
How to Create a Locked Sequence of Buttons	kcackin	PowerPoint	0	01-24-2011 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.