If I have my AF-S on in a manual setting and it can't find the sweet spot, it won't work?

I have a 18-200 vr on order but I've been having second thoughts after reading more reviews. Let me know how you make out with that lens as it is my second choice after I mortgage the house. heheh.