+ Reply to Thread
Results 1 to 3 of 3

Sheet event code: find last row broken?

  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    Syracuse NY
    MS-Off Ver
    2007
    Posts
    90

    Sheet event code: find last row broken?

    I'm making a macro to show or hide rows depending on whether or not a checkbox is checked. I'm using Wingdings font checkboxes, not actual form controls.

    The question: My macro can't find the last row of the used range on the sheet. This is in the sheet's code, set to fire when the selection changes.

    Normally the line in blue works just fine, but it's not working here. In the attached workbook, the macro thinks the last used row is row 19, when it's actually row 21. What's going on?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by jrussell; 07-24-2009 at 03:37 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sheet event code: find last row broken?

    Please Login or Register  to view this content.
    To see why you need to do this, in the Immediate window, enter

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-11-2008
    Location
    Syracuse NY
    MS-Off Ver
    2007
    Posts
    90

    Re: Sheet event code: find last row broken?

    Whoa, thank you, very awesome! Worked like a charm, after I replaced the first instance of that line and deleted the second.
    Last edited by jrussell; 07-24-2009 at 04:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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