+ Reply to Thread
Results 1 to 2 of 2

Excel macro Run-time error '1004': Method 'Range' of object'_Global" failed

  1. #1
    Registered User
    Join Date
    02-13-2019
    Location
    Oslo, Norway
    MS-Off Ver
    Office 365
    Posts
    1

    Excel macro Run-time error '1004': Method 'Range' of object'_Global" failed

    We are trying to set up a macro to split the content of cells into columns by recording a macro using the convert text to columns function in Excel.

    The macro stops with the following error message: Run-time error '1004': Method 'Range' of object'_Global" failed

    Please Login or Register  to view this content.
    I am not a VB programmer and all I am trying to achieve is by using standard macro recording in Excel.
    I have seen several posts on the same subject, but none of the replies have given me any clues on how to solve my problem.

  2. #2
    Registered User
    Join Date
    03-21-2012
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    23

    Re: Excel macro Run-time error '1004': Method 'Range' of object'_Global" failed

    Hey,

    Are you doing text-to-columns to a table object?
    Have you tried to change Range("WorkItems[[#Headers],[Outline Number2]]") with Range("B1")?

    Cheers,
    Adrian B.

+ 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. Run-time error '1004': Method 'range' of object '_Global' failed
    By rubenidas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2016, 05:14 PM
  2. run-time error '1004' method 'range' of object '_global' failed
    By nosense in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-22-2015, 01:39 PM
  3. Run-time error '1004' Method 'Range' of object'_Global' failed
    By mbie451 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2014, 01:40 PM
  4. [SOLVED] Run-time error 1004 - Method 'Range' of object'_Global' failed
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2013, 03:33 PM
  5. "Run-time error '1004' : Method 'Range' of object'_Global' failed
    By Optiprime in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2013, 06:01 AM
  6. Run-time error '1004'. Method 'Range' of object '_Global' failed
    By mjj347 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2012, 11:09 AM
  7. Run-time error '1004': Method 'Range' of object '_Global' failed
    By Neild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2006, 07:50 PM

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