Is this for a worksheet formula?
=indirect(g3)
in H3

if for vba:

with activesheet
.range("H3").value = .range(.range("g3").value).value
end with




Nauman wrote:

Hi,

It's probable very stupid easy, but I cannot seem to figure it out.

I have three cells. F3,G3,H3

F3 = 23 (number)
G3= $F$3 (as text)

Now, in third cell i want to have a formule that would give me some
thing like following. (Ofcourse it's a psudo code.)

H3= value(G3)=23 or H3=value($F$3)=23 but I cannot pass the
value $F$3 but only the cell address G3.

Any idea?

Thanks in advance for you help.

--

Dave Peterson