its just not working. i am also getting a compile error: invalid outside
procedure every time. there's something about that 'am52' cell or range
that is not agreeing with anything i do and i don't have a clue what is
wrong. there's nothing special about the way its set up. thanks for all
the help gord. can anyone tell me now how i can keep this 'personal'
workbook from popping up now every single time i open excel? i hate
that, i don't run any other macros in any of my other sheets and its
never popped up all the time before but it does now.


--
cnote
------------------------------------------------------------------------
cnote's Profile: http://www.excelforum.com/member.php...o&userid=26184
View this thread: http://www.excelforum.com/showthread...hreadid=553206