Hi Gord,

I din't want to add anything to another cell in case that cell was or could be used for something else.

--
Cheers
macropod
[MVP - Microsoft Word]


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
I saw that.

Just wondered why the elaborate macro to add all those Comments that don't
give OP what he asked for in the first place.

To achieve the same thing as your macro without the Comments just enter
=ShowFormula(cellref) in an adjacent cell..............

Function ShowFormula(Cell)
Application.Volatile
ShowFormula = "No Formula"
If Cell.HasFormula Then ShowFormula = Cell.Formula
End Function

But still does not do what OP wantes.


Gord

On Thu, 28 Aug 2008 16:03:17 +1000, "macropod"
wrote:

Hi Gordon,

I noted the limitation as to what can be displayed in my reply.