loud revving while in drive only. but nothing while in idle? on 2010 Chevrolet Cobalt

check engine light turned on. diagnostic done on it and says its a camshaft position sensor. but the loud revving feels like its from the transmission

Asked by for the 2010 Chevrolet Cobalt
Have a 'mechanic' test drive it!