Consulting

Results 1 to 12 of 12

Thread: Text to Rows Macro : Subscript out of range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-04-2018, 11:56 PM #1
    bhrigu
    bhrigu is offline
    VBAX Regular
    Joined
    Jun 2018
    Posts
    7

    Text to Rows Macro : Subscript out of range

    Hi Guys,

    I am trying to perform a text to rows for comma delimited column entries. I have included the screenshot of the raw data and the clean data. I am also including my code and a screenshot of it in the excel vba window. If you could please guide me with what I am doing wrong I would really appreciate it.

    Please assume columns B and C are switched around. I forgot to make that change!

    Capturevba.JPGCapturevba2.JPGCapturevba3.JPG
    Last edited by bhrigu; 11-04-2018 at 11:58 PM. Reason: The system wouldn't let me attach my code or images.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules