+ Reply to Thread
Results 1 to 3 of 3

Work sheet change event only on pouplated rows

  1. #1
    Forum Contributor
    Join Date
    06-30-2014
    Location
    London, England
    MS-Off Ver
    365 & 2010
    Posts
    107

    Work sheet change event only on pouplated rows

    Me Again

    Ok... I have a worksheet change event that fires a username and date when a range of cells have been amended.

    What I would like it to do is only to work when the row is populated.

    So for example if row 1:5 is populated then the worksheet change event kicks in if row 6:10 is blank then the worksheet change event is disabled.

    I'm trying to use:

    Please Login or Register  to view this content.
    With very little success but that could be because I don't know where to add it within the Worksheet_Change(ByVal Target As Range) code?

    I've tried this with the help from Google:

    Please Login or Register  to view this content.
    But I get a runtime error 438. Object doesn't support this property or method

    Any ideas?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,748

    Re: Work sheet change event only on pouplated rows

    Your description has some contradictions. What do you mean by "row is populated"? What row do you want to check--the row containing the changed cell?

    Can you please provide your file with a concrete example of what you want to do? The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

    The second bit of code you provided has a couple of problems. First, it is only checking whether the cell that changed is somewhere in columns A:Z and from row 2 to the last row of existing data. It doesn't address your issue of whether a particular row is populated.

    Second, you do not want to disable events. That will cause you all kinds of complications. If you do not want to do the processing in a particular case, just use an If statement or exit the sub. I can be clearer about this once we determine exactly what condition you need to check.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    06-30-2014
    Location
    London, England
    MS-Off Ver
    365 & 2010
    Posts
    107

    Re: Work sheet change event only on pouplated rows

    I think I have worked it out...

    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] textbox change event sheet reference will not work if another workbook open
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2017, 08:48 AM
  2. Can't make combobox change event to work.
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 10:49 AM
  3. [SOLVED] change event AND calculate event on the same sheet
    By lauriejerome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2013, 03:54 PM
  4. Sub won't work on change event
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2010, 02:10 PM
  5. Sheet Change Event wont work
    By Strugglin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2009, 10:35 AM
  6. [SOLVED] Change event fails to work
    By Mark F in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2005, 08:10 AM
  7. [SOLVED] worksheet change event doesn't work
    By gig in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2005, 11:06 AM

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