Quick Question???

[hemants]

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

 

[Bob Phillips]

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")