$ macro

[david graham]

I need a macro that will put $'s before the col & row for all cells references used in a formula contained in a cell.

 

[jbeaucaire]

Gordon Dibben has written some macros to do what you want. You can get the code for those macros here:

http://www.tech-archive.net/Archive/Excel/microsoft.public.excel/2008-12/msg01117.html