+ Reply to Thread
Results 1 to 3 of 3

Getting error Method 'Range' of object '_Global' failed

  1. 12-20-2013, 04:30 PM #1
    ks100
    ks100 is offline
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Getting error Method 'Range' of object '_Global' failed

    I have a script that copies a range of formulas from another workbook into the active workbook, then is supposed to autofill them down to the last row. For whatever reason though I am getting an error on the autofill line:


    Please Login or Register  to view this content.
    Last edited by ks100; 12-20-2013 at 04:36 PM.
    Reply With QuoteRegister To Reply
  2. 12-20-2013, 04:35 PM #2
    ks100
    ks100 is offline
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Re: Getting error Method 'Range' of object '_Global' failed

    Nevermind, thought LastRow was a built in command, forgot to define it:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 12-20-2013, 04:35 PM #3
    ks100
    ks100 is offline
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Re: Getting error Method 'Range' of object '_Global' failed

    doublepost
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Method 'Range' of object '_Global' failed error
    By RxMiller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2011, 11:06 AM
  2. Error: Method 'Range' of object '_Global' failed
    By awan0126 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2011, 07:25 PM
  3. VBA Method 'Range' of object '_Global' failed error
    By JKCincy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2009, 07:46 PM
  4. Method 'Range' of object' _Global failed error
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2009, 01:52 AM
  5. [SOLVED] Error 1004 Method 'Range' of object '_Global' failed
    By bjwade62 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2006, 11:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1