working with a named range

[Guest]

hi all,

i'm looking to figure out how to use a named range and get its value into a
new cell, but not the reference, the actual value

ie

dim loc as range

loc.formular1c1="=NamedRange1"
will put the reference to where NamedRange1 points - and will change when
NamedRange1 changes. however i need the copy to be 'static'

any suggestions?

tia

J

 

[Tom Ogilvy]

loc.formular1c1="=NamedRange1"
loc.formula = loc.value

or

loc.Value = Range("NameRange1").Value

 

[Don Guillett]

how about
range("a2").value=[namedrange1]