You cannot call a macro from a cell, only a function which will return a
result.

However, from your example what you seem to need in G5 is simply

= INDIRECT(G1&"!$G$4")

--

HTH

RP

"hemants" wrote in message
...

can i use macro's in cells on a worksheet? If possible, how would i
type it out.

i.e. in cell G5 = (activecell.value = G1&"!$G$4")

or something to that effect without havnig to create a macro.


--
hemants
------------------------------------------------------------------------
hemants's Profile:
http://www.excelforum.com/member.php...o&userid=15031
View this thread: http://www.excelforum.com/showthread...hreadid=267973