'Run-time error "1004" on Worksheet_Change

I'm trying to change the value of cell "GN" based on the value of "H" but I keep getting a 1004 error "method range of object'_worksheet' failed". Does it have anything to do with using target.row? The code looks like this:

Worksheet Change(ByVal Target As Range)

i=target.row

If range("H" & i).value = "Rejected" Then
range("GN" & i).value = "Inactive"
End if

It works, but it immediately crashes and shuts down excel. Any suggestions?

vba worksheet

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Run-time error "1004" on Worksheet_Change

Sources

Related Questions