SETTING RANGE VALUE TO ZERO-simple question

[navyaa]

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"

 

[Joe Was]

Sub myTestVal()
Worksheets("Sheet1").Select
Range("PYRCHK") = 0
End Sub

This works when the named range "PYRCHK" is: "A1" on "Sheet1" for me. JSW

 

[Andrew Poulsom]

You do not have to select a range to work with it. And you do not need to use the Formula or FormulaR1C1 properties if you only want to assign a value.

So:

Range("PYRCHK").Value = 0

will do the trick.

Also since Value is the default property of a range object you can shorten it even further:

Range("PYRCHK") = 0

I don't do that myself because it makes the code less readable.

 

[Joe Was]

This also works:

Sub my2ndTest()
[PYRCHK] = 0
End Sub

 

[navyaa]

thank you....

all worked great

Hope you all have a good day

Navya.