Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question???
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question???
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick question... | Excel Worksheet Functions | |||
quick question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Worksheet Functions | |||
Quick Question | Excel Discussion (Misc queries) | |||
Quick If Question | Excel Programming |