You might be thinking Hale Bop. I believe that Marshall McLuhan and Christina Applegate rode away on a spaceship with that one.
I might well be. Sometime around then there was also an event with all the planets in a row. Whatever Im remembering was in the later half of the 90s