I sometimes want to convert a cell from a direct relationship to another cell (i.e. =E54) to having its own value NOT related to the original cell (which might change in value weekly).
I do this by clicking the copied cell, Edit copy, Edit Paste Special, Values and finally clicking Esc to remove the dotted lines. The cell now has the number without reference to the original.
You would think turning this into a macro would be pretty simple but whenever I try it and run the macro it always wants to do the job from the same cell, whereas I want to use this feature on any cell in any workbook. I stored the macro, named values, in the Personal.XLS workbook.
Can anyone explain what I am doing wrong?

Also, I have a backup program and I would like to backup Personal.XLS periodocally but I cannot find where this file is located and so I cannot tell my backup prrogram where to find it. Any ideas?

johnni