If statement not working

Hi,
Hope someone can help me with this. I'm kind of new to VBA/Excel.

I have a worksheet with a print button on. User can input quantities in column A, rows A3:A50. Rows A4:A8 print one PDF file if a quantity is in any of those rows. Other ranges print a different PDF file, in all there are 15 different ranges that print a different PDF. User may have multiple values in these ranges, but I want only one PDF to print.

The If statement I created, searches this range and prints only one PDF per selected range, but after about row A29, it prints the PDF file for range A4:A8between the other ranges that were selected.

Is this common with If statements?

Any suggestions?

Thanks,
LIT2003