need help with If statments or VB if possible

jerryj · #1 05-02-2012, 11:01 AM

What im trying to do is, if sheet2!A1:A5 is updated then id like to put a "*" on sheet1!A1:A5

Peter Wienand · #2 05-04-2012, 08:24 AM

You could try something like this in the Sheet2's worksheet change event

Code:

 
Private Sub Worksheet_Change(ByVal Target As Range)   Dim c As Range
 
    For Each c In Target.Cells
        Sheets("Sheet1").Cells(c.Row, c.Column).Value = "*"
    Next c
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode