View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett
 
Posts: n/a
Default Indirect Formula

cell a16 had the worksheet name typed into it.

--
Don Guillett
SalesAid Software

"lmullenjr" wrote
in message ...

I have inherited a spreadsheet from a former employee and cannot figure
out the Indirect formula he used. Can someone explain the following:


INDIRECT("'"&$A16&"'!G15")

Thanks

Larry


--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile:
http://www.excelforum.com/member.php...o&userid=33132
View this thread: http://www.excelforum.com/showthread...hreadid=540658