In H2 I have =TODAY() formula. Need for that date to be added to cell in column F & active row. ADDED is the key word - I am going to be calling this macro from another, which sends email and this macro is meant to keep recording every date email is sent for this line item. Code I have so far is below, but getting "Run-time error'424' Object required" on line
Code:
Set Rng = Range("F" & (ActiveCell.Row)).Value
Code:
Sub AddEmDate()
Dim Rng As Range
Dim c As Range
Set Rng = Range("F" & (ActiveCell.Row)).Value
c.Value = c.Value & ";" & Range("H2").Value
End Sub