Results 1 to 13 of 13

Change cell when other cells in row are changed - check all rows

Threaded View

ghoshl1 Change cell when other cells... 08-27-2012, 07:21 AM
arlu1201 Re: Change cell when other... 08-27-2012, 07:26 AM
ghoshl1 Re: Change cell when other... 08-27-2012, 07:36 AM
tom1977 Re: Change cell when other... 08-27-2012, 07:29 AM
tom1977 Re: Change cell when other... 08-27-2012, 07:37 AM
ghoshl1 Re: Change cell when other... 08-27-2012, 07:40 AM
tom1977 Re: Change cell when other... 08-27-2012, 07:45 AM
ghoshl1 Re: Change cell when other... 08-27-2012, 07:52 AM
tom1977 Re: Change cell when other... 08-27-2012, 08:05 AM
tom1977 Re: Change cell when other... 08-27-2012, 08:04 AM
ghoshl1 Re: Change cell when other... 08-27-2012, 08:09 AM
Cutter Re: Change cell when other... 08-27-2012, 11:02 AM
ghoshl1 Re: Change cell when other... 08-27-2012, 11:05 AM
  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Basel, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    29

    Change cell when other cells in row are changed - check all rows

    Hi All,

    I'm having trouble with the following:

    1. Need to check each row individually - and if from columns b through n and column r are changed - modify column a to say "updated".

    I'm using the code below for the continuous range - but I need it b-n and then r...

    Also it seems to work once - then doesn't not work again.

    Help????

    Private Sub Worksheet_Change(ByVal Target As Range)
    
    Dim cl As Range
    
    If Not Intersect(Target(1, 1), Range("B:R")) Is Nothing Then
        Application.EnableEvents = False
        For Each cl In Target(1, 1)
        Cells(cl.Row, 1) = "Updated"
        On Error Resume Next
        Application.EnableEvents = True
        Next
        End If
    
    On Error GoTo 0
    End Sub
    Last edited by arlu1201; 08-27-2012 at 07:25 AM.

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