hi,
I have a set of numbers indicating the start value and stop value. I need to expand the range and fill the numbers in between. the step value for filling the numbers is constant (or 1). The fill option only works for one cell. I have to repeat the action for around 500 line items. can someone help me out in this?
Last edited by sibi1994; 08-03-2021 at 05:23 AM. Reason: Added sample excel file
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
There is no 2008 version of Excel - are you using MS365? Please update your profile.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
Yes , I am using MS365. I have updated my profile. Also, I have attached a sample workbook. Also, please bear with me as I am quite new to this forum.
Looking forward to your suggestions regarding my query.
Regards,
sibi
Try this:
HTML Code:
Last edited by tanasedn; 08-03-2021 at 06:13 AM.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
given O365, formula wise... and, rest assured, there will be better methods...
Formula:
Please Login or Register to view this content.
It works. Thank you, Diana. you saved a great deal of my time and effort.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thank you Xlent
Hi Diana, probably worth noting that in the above only j is initialised as Long the others will default to Variant, in VBA each element (on any given line) must be declared individuallyOriginally Posted by tanasedn
Please Login or Register to view this content.
Please Login or Register to view this content.
worksheet name : output
Cell B2 formula , Drag down
HTML Code:
Thanks, Xlent! But now? I am still learning and I really appreciate those who help me in this direction! And I'm abusing Google translation
HTML Code:
Yes, you can use these Type Character Suffixes but, to my knowledge, it's generally considered better practice to use "As" given the character suffixes persist for backwards compatibility.
(that said, I am sure some people on this board will disagree...)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks