i have the following change event that i have modified to insert row count. Unfortunately im still learning change events procedures and need a little help putting in the formula syntax. how do i correct this?
if Column C <> blank then insert formula =Row()-3 in target.row column A. Headers are in row 3. data starts on row 4.
If Target.Column = 3 And Target.Row > 3 And Target.Value <> "" Then
Application.EnableEvents = False
Target.Offset(0, -2) = Formula = "=ROW()-3" <<<<<<this just returns "FALSE" in column A. it should be row count.
Application.EnableEvents = True
if Column C <> blank then insert formula =Row()-3 in target.row column A. Headers are in row 3. data starts on row 4.
If Target.Column = 3 And Target.Row > 3 And Target.Value <> "" Then
Application.EnableEvents = False
Target.Offset(0, -2) = Formula = "=ROW()-3" <<<<<<this just returns "FALSE" in column A. it should be row count.
Application.EnableEvents = True