If statement not working

**lit2003** · 01-24-2008, 06:45 PM

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

**Leith Ross** · 01-24-2008, 07:32 PM

Hello lit2003.

Welcome to the Forum!

Before anyone can give you an answer, you need to post your code and/or workbook. You can only attach workbooks that have been zipped and are 100kb or less in size.

Sincerely,
Leith Ross