You can if you setup the range in the other sheet as a name
(InsertNameDefine Name...) and use that name in the CF.

HTH

Bob

"Seanie" wrote in message
...
Thanks

Slight issue it says I can't use references to other worksheets in CF