I recorded a macro, and then looked at the code.
' Macro1 Macro
ActiveCell.FormulaR1C1 = "Active"
I know this code can be streamlined quiet a bit, so here is what I would like.
Step 1: "Clear Contents" of named cell (part of merged cells): RVName & RVFreeze.
Step 2: Type "Active" into named cell (part of merged cells): RVStatus.
Thank you in advance for your help!