I was in my friend's 2003 Cavalier today & when the car is in drive there is a funny noise. It sounds like a rattling orrapid clickingnoise, but goes away when the car is in any other gear. Could it be a problem with the transmission or a solenoid constantly clicking? The car has approximately 90400 miles. There are no shifting issues or trouble codes.

Any input is appreciated

 

sounds to me like a rusted loose heat shield on the exhaust. try tightening them or even remove them.

 

if it was a heat shield it will do it when stoped

 

Oops, my bad.. I should have mentioned that it is when the car is at a stop while in drive. I'll take a look at the heat shields on the exhaust to see if any are loose or whathaveyou. The one on the manifold should be tight since I removed & reinstalled it to get to the o2 sensors but just for kicks I might go ahead & remove it to see if the noise goes away.