GTO
02-11-2009, 01:19 PM
Greetings to all, and a Howdy to those I know,
Anyone with 2000 wanna run a simple test for me?
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "WorkSHEET_Change activated,", 0, ""
End Sub
...and...
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Workbook_SheetChange activated.", 0, ""
End Sub
In short - I was looking to use the Change event to detect when a row was added or deleted. Seemed to be working fine in 2003, but in 2000, it was detecting deleting rows, but would blow right by adding them.
So, I am curious as to whether the causal is is my poor ol' laptop, or an Excel oddity.:dunno
Edit: forgot to mention that the test would be to then delete and add rows to the appropriate sheet and see whether the msgboxes display upon adding rows / deleting rows / or both...
Thank you so much,
Mark
Anyone with 2000 wanna run a simple test for me?
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "WorkSHEET_Change activated,", 0, ""
End Sub
...and...
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Workbook_SheetChange activated.", 0, ""
End Sub
In short - I was looking to use the Change event to detect when a row was added or deleted. Seemed to be working fine in 2003, but in 2000, it was detecting deleting rows, but would blow right by adding them.
So, I am curious as to whether the causal is is my poor ol' laptop, or an Excel oddity.:dunno
Edit: forgot to mention that the test would be to then delete and add rows to the appropriate sheet and see whether the msgboxes display upon adding rows / deleting rows / or both...
Thank you so much,
Mark