Named ranges and VBA

[Timmy Mac1]

If I have a cell in my spreadsheet named PICKVALUE and I wish to reference it in a macro using the IF function (eg to get the macro to do something if the value of PICKVALUE is above 2000) can I use the name PICKVALUE without redefining it in VBA?

[anilsolipuram]

you can reference the named cell by using range("PICKVALUE")

if(range("PICKVALUE").value>2000) then
' your code
end if

[Timmy Mac1]

Many thanks