Results 1 to 3 of 3

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

Threaded View

ks100 Run-time error '1004' :... 10-14-2015, 09:42 AM
romperstomper Re: Run-time error '1004' :... 10-14-2015, 09:46 AM
ks100 Re: Run-time error '1004' :... 10-14-2015, 09:47 AM
  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

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

    It highlights the bold row below with this error, any idea why?


    If Range("al").Value <> "info" Or Range("b2").Value <> "info" Then
    
    MsgBox "Workbook does not appear to be a report. Please make a report the active workbook before continuing.", vbCritical
    Exit Sub
    
    End If
    Nevermind, had an "l" instead of a 1.
    Last edited by ks100; 10-14-2015 at 09:47 AM.

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 nosense in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-22-2015, 01:39 PM
  2. 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
  3. Run-time error '1004: Method 'range' of object'_Global' failed
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-01-2014, 05:56 AM
  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 mjj347 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2012, 11:09 AM
  6. Run-time-error 1004 -- Method 'Range' of object '_Global' failed
    By tilleyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2012, 10:55 PM
  7. Run time error 1004 - Method 'Range' of 'Object'_Global' failed
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-10-2009, 01:18 PM

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