Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Exclamation Unanswered: help me with this problem plzz

    can anyone help me out on this qns plz?

    how do you write the code for the following situation:

    if there are sheet1 and sheet2, and the cells correspond to each other,how do u type the code for macro in VB? when any cells in sheet2 is being edited, moved or deleted, the corresponding cells in sheet 1 is being highlighted automatically

    plz help me ASAP by posting the code on this thread or send the codes to

  2. #2
    Join Date
    Jan 2004
    Aberdeen, Scotland
    Something like this
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Worksheets("Sheet2").Range(Target.Address).Value <> _
                Worksheets("Sheet1").Range(Target.Address).Value Then
            Worksheets("Sheet1").Range(Target.Address).Interior.ColorIndex = 3
        End If
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts