It's a rather elementary question but my head is currently in the sand...How can I get a DDE link to reference another cell in an Excel worksheet? e.g. Quote!'fld:CHOZ04(A12).OldSet' meaning the cell reference would be in place so you don't need to manually change the strike price you're seeking, only input into cell A12

Anyone?

I don't think there is a simple solution to your problem. I have written my own dlls which simplify the DDE stuff so you can do stuff like=quote(A1) where A1 may be something like IBM,LAST and can change dynamically. I am afraid I dont let that software go for nothing.There is an elegant half way house to you problem. Whta you can do is create a sheet where you have all you DDE links. so u have somethingRIC LAST BID ASKDELL.OGE.NIBM.N MSFT.Oand using vlookup u can then do what you are trying to do.

HeatOilTrader,this is a question that pops up every now and then on the MS Excel newsgroupsand I cannot remember having seen a satisfying solution to your problem.Of course you can always try fixes like using macros or coding in a dll as daveangelwrote.Look athttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnexcl2k2/html/odc_xlrtdfaq.asp"What is Wrong With Dynamic Data Exchange (DDE) for Real-Time Data?DDE can't use cell references in a function; everything must be hard coded. "We have changed to RTD-server (Real Time Data) solutions because of this. This feature is available since Excel XP. Unfortunately, RTD-servers are not available for all data providers yet.Hans-Marc

Thanks, I guess I'm going to stick with old faithful, VB, for the time being...