Disregard second posting, wrong thread.


"JLGWhiz" wrote in message
...
Or:

Range("J10").Select
ActiveCell.FormulaR1C1 = Range("Y1"),Value
Range("J11").Select
ActiveCell.FormulaR1C1 = Range("Y2").Value




"JLGWhiz" wrote in message
...
One way:


Sub dk()
MsgBox ActiveCell.Name.Name
End Sub


"James Price at Premier"
wrote in message
...
I have a worksheet which has a number of Range names. Each named range
relates to one cell only. There will be no instances of more than one
range
name in a cell. Can I use VBA to check if the Active Cell has a range
name
in it.

Many thanks

James