+ Reply to Thread
Results 1 to 2 of 2

Run-time error '1004' Text to columns method of range class failed

  1. #1
    Registered User
    Join Date
    04-23-2021
    Location
    d
    MS-Off Ver
    v3
    Posts
    1

    Post Run-time error '1004' Text to columns method of range class failed

    hello guys, im trying to run this macro on a huge amount of data and every time i receive this error
    thanks for the help in advance
    Run-time error '1004' Text to columns method of range class failed

    Selection.TextToColumns=Destination:=Range("B2"), DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
    :="|",FieldInfo:=Array(Array(1,9), Array(2,1), Array(3,9), Array(4,1), Array(5,9), Array(6,1), Array(7,9), Array(8,1), Array(9,9), Array(10,1), Array(11,9), Array(12,1), Array(13,9), Array(14,1), Array(15,9), Array(16,1), Array(17,9), Array(18,1), Array(19,9), Array(20,1), Array(21,9), Array(22,1), Array(23,9), Array(24,1), _
    TrailingMinusNumbers:=True

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,054

    Re: Run-time error '1004' Text to columns method of range class failed

    Possibly...
    Please Login or Register  to view this content.

    BTW, read the forum rules.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    ____________________________________________________________
    If I've been helpful, let me know. If I haven't, let me know that too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run time error '1004' - Copy method of Range class failed
    By jeffrie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2020, 10:49 AM
  2. [SOLVED] Run time error 1004: PasteSpecial method of Range class failed
    By Ollie7957 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-27-2016, 06:40 AM
  3. [SOLVED] Run-time error '1004': Delete method of Range class failed
    By Nobo1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2016, 03:01 AM
  4. Run-time error '1004': PasteSpecial method of Range class failed
    By jaghuar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2015, 07:35 PM
  5. Run Time Error '1004': Select method of Range Class failed VBA
    By jcgonzales in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 02:29 PM
  6. Run-Time Error '1004' AutoFill method of Range class Failed
    By RS944 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2013, 11:37 AM
  7. Run-time error '1004': Select Method of Range Class Failed
    By hazza147 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-22-2010, 07:19 AM

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.6.0 RC 1