+ Reply to Thread
Results 1 to 4 of 4

cannot understand error with range handling

  1. #1
    Forum Contributor
    Join Date
    09-12-2013
    Location
    chicago, illinois
    MS-Off Ver
    Excel 2010
    Posts
    109

    cannot understand error with range handling

    hello all, for the life of me i cannot figure out why i am receiving an error here. i am simply trying to select the last used cell in a named range. i keep receiving the error: object variable or with block variable not set.

    Please Login or Register  to view this content.
    thanks

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: cannot understand error with range handling

    Try this...

    Please Login or Register  to view this content.
    Hope this helps.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    09-12-2013
    Location
    chicago, illinois
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: cannot understand error with range handling

    thank you very much. i'm not sure why i cannot grasp that concept as i have failed there before....*sigh* still learning!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: cannot understand error with range handling

    Not a big issue. Sometime it happens with everyone. So just relax. Glad to help you.

+ 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. Error Handling: Start - End range for Listbox
    By cmore in forum Excel General
    Replies: 0
    Last Post: 10-11-2013, 03:32 PM
  2. [SOLVED] trying to understand why a code is not working "error 9 subscript out off range"
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2013, 12:33 PM
  3. Error handling when dynamic name range is empty
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2010, 10:11 AM
  4. Don't understand error with Range()
    By achinfish in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2007, 09:08 PM
  5. Error handling with a handling routine
    By ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 11: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