Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Target, an argument in the worksheet_Change event holds a reference to what
has changed. Right click on the sheet tab and select view code. Put in code like this: Private Sub Worksheet_Change(ByVal Target As Range) MsgBox Target.Address End Sub Then play around with your sheet. -- Regards, Tom Ogilvy "TimD" wrote in message ... I am using the Worksheet_Change event to manipulate data on a sheet. Can I capture the event that has caused a change to the worksheet. Like the difference between deleting an entire row and deleting a specified range. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_change event. | Excel Programming | |||
Worksheet_change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change Event Not Working | Excel Programming |