MACATTACK_VA
New Member
- Joined
- Jun 15, 2012
- Messages
- 5
Hello all - 'long-time visitor, first-time poster.
I've created a macro in protected worksheets that enters the date and time in the "I" column whenever a cell in the associated row has been modified.
This was working great when I left the office on Friday but this morning whenever I try to modify a cell it stops me and gives me an error message that reads Run-time error '1004': Out of stack space.
The code I've inserted for two worksheets that populate the data into another dozen worksheets is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 1 Then Cells(Target.Row, "i") = Now()
End Sub
The portion in red is what's highlighted when I go to the debugger.
Any thoughts/assistance would be greatly appreciated!
I've created a macro in protected worksheets that enters the date and time in the "I" column whenever a cell in the associated row has been modified.
This was working great when I left the office on Friday but this morning whenever I try to modify a cell it stops me and gives me an error message that reads Run-time error '1004': Out of stack space.
The code I've inserted for two worksheets that populate the data into another dozen worksheets is:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 1 Then Cells(Target.Row, "i") = Now()
End Sub
The portion in red is what's highlighted when I go to the debugger.
Any thoughts/assistance would be greatly appreciated!