+ Reply to Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18

Thread: Excel Split Single Cell Array into Multiple Cells

  1. #16
    Registered User
    Join Date
    06-08-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Excel Split Single Cell Array into Multiple Cells

    I have Sheet1 and Sheet2. With the data on either 1 or 2, when I run it, I get that error.

    Could somebody use the Template I uploaded and attach a working Macro to it possibly? I'm good with Excel, just never used Macros before.

  2. #17
    Registered User
    Join Date
    06-08-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Excel Split Single Cell Array into Multiple Cells

    Ok, I made a new document and tried again. It worked without an error, but all it did was copy the data over to Sheet2 in the same format.
    Last edited by devinpitcher; 06-08-2011 at 01:48 PM.

  3. #18
    Registered User
    Join Date
    06-08-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Excel Split Single Cell Array into Multiple Cells

    Solved. I checked my post on Stack Overflow, and they came up with something that worked.
    Last edited by devinpitcher; 06-09-2011 at 08:27 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0