Then you will need a macro. cell AA6 cannot put data in e6 via cf or a
formula.

--
Don Guillett
SalesAid Software

"jzzman" wrote in
message ...

BTW,

I didn't mention my formula is not in cell E6 I need it to be in cell
AA6.


--
jzzman


------------------------------------------------------------------------
jzzman's Profile:
http://www.excelforum.com/member.php...o&userid=24838
View this thread: http://www.excelforum.com/showthread...hreadid=549193