Coding Multiple Cases in VBA

**billofsoo** · 03-24-2009, 09:10 PM

VBA NOOD

I think I spoke too soon.

It seems that if the first two cells are >50 then only their associated arrays print - like it is supposed to work.
If the first cell is less than 50 then the first associate arrays doesn't print - like it is supposed to work..
BUT
If the first third and sixth cells are less than 50 then the first array does not print but ALL the others do.

Don't know why....can you consider why this might be happeing?

Thanks

**billofsoo** · 03-24-2009, 09:35 PM

VBA Nood

Actually if all cells are less than 50 except the first cell then ALL arrays are printed. Can't see any problem with the code at all. In fact if only the third cell is greater than 50 then all pages still print. Weird!

Let me know what you think - it is late here..need to go home. Will check for a response in the morning.

Thanks a lot for your patience.

BillofSoo

**shg** · 03-25-2009, 12:36 AM

Threads merged.

**VBA Noob** · 03-25-2009, 03:27 AM

Using my example again it all seem to work.

Post your file (remove any info) and I'll take a look or go with the other option you got

VBA Noob

**billofsoo** · 03-25-2009, 05:09 PM

Thanks VBA Noob

I have stripped out the info from the worksheet - left some in as well along with some notes so you don't have to work hard to figure out how I set this up. I included three modules you have seen and adjusted them to match my exact cell/array locations.

Best of luck...hope you get this.

Best regards,

BillofSoo

**VBA Noob** · 03-25-2009, 05:16 PM

The missed changing one range address

ArrRng = Array("K28", "J38", "J50", "J61", "J73", "J93")

Is that you're problem?

VBA Noob

**billofsoo** · 03-25-2009, 05:42 PM

VBA Noob

I know what the problem is....in the cells that are tested >50, I have formulas!!! you have just numbers. When I put straight numbers in column K and adjust the module to accommodate, this code works as it is supposed to.

How can I get the value obtained through the formula to appear in another cell as a value only?

That will solve the problem.

BillofSoo