Hi there

Need your help please on my recorded macro;

ActiveCell.FormulaR1C1 = "GADNN01",

The "GADNN01" is different from every data, so how can i change to variable so as when i open this macro, the macro will detect whatever name as that line?

appreciate for your help