I thought you said you got rid of the comile error by checking a missing
reference?


Gord

On Tue, 18 Aug 2009 10:27:01 -0700, Melanie
wrote:

i tried both and they still don't work with the same compile error.
i'm pretty sure it has something to do with the workbook... there are no
typos in my code.
unfortunately i can't send this workbook as it's work-confidential. :(
oooh well... thanks anyway.