Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Converting sequential numbers in one column to ranges in two columns
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,247
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Converting sequential numbers in one column to ranges in two columns

    Quote Originally Posted by Peter_SSs View Post
    BTW, were you still a little verbose with your previous code?
    That is, wouldn't this have done?
    You know me, I always like to post long code procedures. Originally, I was going to try and approach the solution differently and when it didn't work out as I had hoped, I carved up the code I had and what I posted was the result (looks like I should have just thrown it away and started over again).



    Quote Originally Posted by Peter_SSs View Post
    That is, wouldn't this have done?
    Yes, of course... but you already knew that.
    Last edited by Rick Rothstein; Sep 23rd, 2019 at 01:55 AM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  2. #12
    New Member
    Join Date
    Sep 2019
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting sequential numbers in one column to ranges in two columns

    Hi
    Yes I had both codes with numbers and with alphabets in the data. I filtered the data just to include numbers and both the macros from Peter and Rick worked.
    Thank you very much. I will find different way to call out other codes for the data base table. Appreciate all your help.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •