Results 1 to 3 of 3

Error: Method 'Range' of object '_Global' failed

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2011
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    24

    Error: Method 'Range' of object '_Global' failed

    Hi,
    Sorry to be asking such an easy question- struggling to understand why this is displaying an error (the Method 'Range' of object '_Global' failed error)

    Sub macro2()
    Dim myrng As Range
    
    Set myrng = Range("b1:b10")
    
    Range("myrng").Select
    I've tried to dim "myrng" as variant, as object... all I want to be able to do is to select a range that I've pre-defined. I know I could just do Range("b1:b10"), but want to understand why this alternative method doesn't work.

    Thanks!
    Last edited by awan0126; 06-29-2011 at 09:57 AM.

Thread Information

Users Browsing this Thread

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

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