How do I resolve debug error macro Excel 2000? At least, any lead

I am working on Excel 2000 macros and am frequently getting debug errors,
although I notice no mistakes when creating the macros. Somebody please help
!!

Thanks,

m.