Thanks! Much appreciate your help.
"Gary''s Student" wrote in message
...
Dim V as Variant
V=myRef.Value
--
Gary''s Student - gsnu2007a


"Tom" wrote:

I have a reference cell, myRef. How can I :
1. Read its content which is either a text or a number?
2. Use this value elsewhere later?
Thanks for any suggestions.

Tom