Select a range named and replace values

Hi, I have one excel file with values in Colum A. I want Replace 3/1/2013 & 7/1/2013 values with 3-1 and 7-1 each.

For that I've created 2 Ranged names "date3" and "date7", that automatically select only cells with that values.

I Want a Macro to Replace the "Selection" with spesific values. Example to replace 3/1/2013 with 3-1 I have this code

Range("date3").Select 'This Line Doesn't work
Selection.FormulaR1C1 = "3-1" 'This Line Replace The Selection

I'm hable to copy a range named with this code
Range("date3").Copy

So, what is the way to select a Name in VBA?
Thank you.

Thank you both for your help

Originally Posted by Richard Buttrey

Hi,

Do you really need to change the values? Can't you just format the dates with "d - m" > This assumes you do mean 3rd January and 7th January. If your date is m/d/y then format as "m - d" instead.

Yes, because I´m going to still work with that values and I need text no date, I try with your idea but on my excel i need double click on the current cell to apply the change :S, and the cell position ever going to be a variable value.