thank you dave. You're right (again). CT summary does not own that
code. I moved the code to a macro and called the macro and now it
works:)

thank you for the explanation though. I never knew that and it was
driving me insane that it wasnt working. but now i know why:)


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=479822