+ Reply to Thread
Results 1 to 2 of 2

Select method of Range class failed

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Select method of Range class failed

    The below code keeps producing the above error message either the line above Range("A1").Select or below it. For the life of me I cannot work out why this is happeneing.

    Can someone please put me out of my misery and tell me what's wrong with these lines of code?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Select method of Range class failed

    I don't see that Range("A1").select does anything?

    Please Login or Register  to view this content.
    Is there any purpose of having it there at all? Maybe remove it?

+ 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. Select method of range class failed
    By JayWeb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2010, 09:41 PM
  2. Select Method of Range Class Failed
    By Screamtruth in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2010, 07:01 AM
  3. Select method class range failed
    By phillb in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-05-2007, 06:45 AM
  4. Select Method of range class failed
    By excel_rookie74 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2006, 12:17 PM
  5. [SOLVED] What did I do? (Select Method of Range Class Failed )
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-20-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1