Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet_change D.McRitchie
I found Dave McRitchie's code that would work perfect for my post of 9/10 -
Capture date and data... But I can't seem to modify it to allow me set as target multiple cells in diferent locations throughout the sheet and then stamp date and record each change on another sheet. --------------------------- I also found the following code: Private Sub Worksheet_Change(ByVal Target As Range) With Sheets("sheet2") x = .Cells(Rows.Count, "a").End(xlUp).Row + 1 If Target.Address = "$B$4" Then .Cells(x, "a") = Target End With End Sub Which would work perfect if I could combine Dave's code with this one and make it multiple target cells. Could you please give me a hand? As always, very grateful for any help you can give me. I need to date certain cells as they change and copy them to another sheet. I only find |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
David McRitchie (subject header) | Setting up and Configuration of Excel | |||
David McRitchie/Thanks | Excel Programming | |||
Att: David McRitchie | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |