+ Reply to Thread
Results 1 to 2 of 2

Select Method fails

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Select Method fails

    I can't understand why this bit of code is failing
    [CODE][/Private Sub CommandButton4_Click()

    With Sheets("ClickCharges")
    .Range("A1").Select
    End With
    Me.Hide
    End SubCODE]

    I get a "Select method of Range fails" message
    I am sure I must have used this a thousand times before.
    If I can't do it this way, what should I do?

    John

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Select Method fails

    John

    You would need to select the 'ClickCharges' sheet for that code to work.

    See if this works.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. Method 'SaveAs' fails
    By mtpsuresh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2006, 06:25 AM
  2. Resize method fails for 1-D array?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2005, 09:35 AM
  3. Paste method fails in VBA
    By lalu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2005, 11:05 PM
  4. [SOLVED] select method of range class fails
    By mark kubicki in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-27-2005, 10:06 AM
  5. [SOLVED] Workbooks.open method fails
    By JAT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2005, 05:06 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