I just want to know how is it possible to set the value of a named range eg ("PYRCHK") to 1 in the simplest form of code..
I can do it using this but was wondering if there is a simpler way of doing it??
Range("PYRCHK").Select
ActiveCell.FormulaR1C1 = "=0"
I can do it using this but was wondering if there is a simpler way of doing it??
Range("PYRCHK").Select
ActiveCell.FormulaR1C1 = "=0"