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

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

or something to that effect without havnig to create a macro

--
hemant
-----------------------------------------------------------------------
hemants's Profile: http://www.excelforum.com/member.php...fo&userid=1503
View this thread: http://www.excelforum.com/showthread.php?threadid=26797