Hi

Thank you all for replying.

I checked every suggestion. The site I got connected via Valko's reply says
page corruption may be the reason so I stop there. I do not have the problem
in other pages in the file so I have been able to copy the data to an other
page and continue.

Thanks again. Loop closed.

"T. Valko" wrote:

See if this helps:

http://contextures.com/xlDataVal08.html#Freeze

--
Biff
Microsoft Excel MVP


"Varne" wrote in message
...
Hi

In the same workbook I have the above problem in one page only. Throughout
the page.

The cells get validated if validation is done manually or by macro.
However
since there is no arrow a value from the list cannot be selected. Instead
I
have key in a value within the list range.

If anyone has come across such a problem please reply.

Thanks

M Varnendra