Thank you for that Gord - that has been a bugbear to me for ages.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Sandy

When working in the formula is: dialog in CF, hit F2 key then you can use
arrow
keys.

Same for the refers to: dialog in InsertNameDefine.


Gord

On Fri, 20 Jun 2008 14:48:49 +0100, "Sandy Mann"

wrote:

You are not thinking about
the arrow keys in Conditional Formatting where they do enter new cell
references are you?