Maybe it's just that it's 4:45pm and my brain is done, but I can't get this to work.
I need a VBA loop that will give me sequential numbers in column D based on the value of cell B2. So if the value of B2 is 5, then beginning in D1, it'll do 1 2 3 4 5
Any ideas?
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
You can actually do that without VBA. Put this formula in D1 and copy down a few 100 rows.
=IF(OR($B$2="", ROW()>$B$2), "", ROW())
That will show 1 through X where X=B2.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Yasser, that worked great! Thanks so much.
JBeaucaire, that would work too, but I'm already in VBA mode doing some other tasks.
You're welcome. Glad I can offer some help
For chuckles, another version that accomplishes the same thing without a loop, so no matter want the number is in B2, even 150k, it will only write to the sheet twice and be done:
Please Login or Register to view this content.
Simply
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks