Results 1 to 10 of 10

select method of range class failed (sometimes)

Threaded View

  1. #1
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    select method of range class failed (sometimes)

    hey you experts,

    got another problem with the same files I've posted about 3 times now. sometimes this code breaks with the error ""select method of range class failed"":
    With wsDrawings
        LR1 = .Cells(.Rows.Count, 1).End(xlUp).Row
        .Columns("O:O").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
        .Range("O2").FormulaR1C1 = "=IF(ISBLANK(RC[-3]),RC[-1],RC[-3])"
        .Range("O2").Copy
        .Range("O2:" & "O" & CStr(LR1)).Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
    End With
    and sometimes it doesn't. image 1 below shows one run where it actually DID work, broken one line after the offending line that sometimes throw the err. the second image shows that instance worked fine. other than me not killing Excel to dump all the memory before every test run, why would excel do this sometimes and sometimes not?
    Attached Images Attached Images
    Last edited by vba_php; 10-09-2020 at 12:28 AM.

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 falconpunch12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2016, 08:43 AM
  2. Select Method of Range Class Failed
    By lalaluye in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-15-2015, 05:16 PM
  3. Select method of range class error?
    By robbert in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2008, 12:58 PM
  4. Select method of Range class failure
    By jayron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2007, 10:56 AM
  5. 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
  6. Select method of Range class failed
    By Capo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2006, 11:27 AM
  7. Select method of range class failed
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2005, 05:05 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