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

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

or

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

--
Regards,
Tom Ogilvy

"Gixxer_J_97" wrote in message
...
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

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

--
Don Guillett
SalesAid Software

"Gixxer_J_97" wrote in message
...
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