CellColorIndex - not working.
 

Thank you Frank.
Now it works but only if I remove the line
Application.Volatile = True
Error message say that expected function.
Any Idea?

Thanks
Malcom

CellColorIndex - not working.
 

Remove '=' from your line.

Application.Volatile True

Jare

--
Jare
-----------------------------------------------------------------------
Jarek's Profile: http://www.excelforum.com/member.php...info&userid=96
View this thread: http://www.excelforum.com/showthread.php?threadid=26684

CellColorIndex - not working.
 

Hi
sorry, I missed that. The statement is simply
application.volatile

without '= True'

--
Regards
Frank Kabel
Frankfurt, Germany

"Malcom Jazz" schrieb im Newsbeitrag
...
Thank you Frank.
Now it works but only if I remove the line
Application.Volatile = True
Error message say that expected function.
Any Idea?

Thanks
Malcom