+ Reply to Thread
Results 1 to 3 of 3

Problem with Range object

  1. #1
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    242

    Problem with Range object

    Hello again,

    I've been struggling trying to get a procedure that opens an external workbook to perform properly. No matter what I try, I seem to always get a Range Object error or one type or anther. See my code below and note in particular this line... " 'HERE'S THE PROBLEM... IF OPENBOOK CELL IS EMPTY, DELETE THAT CELL'S ROW".

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Problem with Range object

    Just use
    Please Login or Register  to view this content.
    Rows expects a number, not a range object.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Problem with Range object

    When you delete/add row(s)/columns(s), always better loop backwards.
    It will skip every 2nd blanks if there are consecutive rows.
    Please Login or Register  to view this content.
    As Rng has only one column, you could also write like this
    Please Login or Register  to view this content.

+ 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. [SOLVED] problem defining quote sign " in formula property applied to range object
    By mnjofra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-07-2012, 05:18 PM
  2. i am facing problem with range object
    By saanket in forum Excel General
    Replies: 1
    Last Post: 12-27-2011, 04:25 AM
  3. range object as a function parameter problem
    By guss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-30-2011, 05:49 PM
  4. Range object problem in VBA
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2009, 11:33 PM
  5. Range object/property problem.
    By mjsheen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2009, 03:21 AM
  6. amortization table,method 'range' of object _global' failed problem
    By bocah_kuncung in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2009, 04:52 AM
  7. own version of the problem:method 'range' of object'_global' failed
    By jwest21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2008, 06:55 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