Want to paste active cell data within NamedRange down.
I have Named Range of 10 columns lets "Name1".
I type "ABC" on 5th column.
I want to paste value "ABC" till 10th column with in the named range "Name1".
I have tried with below code but no success any help will be appriciated.
Range(ActiveCell, Cells(Rows.Count, ActiveCell.Column + 1).End(xlDown).Offset(, -1)).Value = ActiveCell.Value