IF condition, check more than one cell then Select Case

**blue.chio** · 06-15-2013, 03:09 AM

Hello!

I would like to expand this code to check more than one cell.
If in Sheet2 cell H16 or H17 or H18 or H19 or M16 or M17 or M18 or M19="ABC"value and cell AD10=312A or 312B to add text in Sheet3.
If the conditions are met to add some text.
Thanks a lot for your help.

this is what I have, it works but it checks sheet2 and one cell (m16) only.

Please Login or Register  to view this content.

blue

**Tinbendr** · 06-15-2013, 08:51 AM

How about this?

Please Login or Register  to view this content.

**blue.chio** · 06-15-2013, 09:37 AM

Hello David,
Thank you for your solution, one more thing,
colud you add a condition for aCell *if there is "ABC".value (check each cell), please?

blue

**Tinbendr** · 06-15-2013, 09:43 AM

Sorry about that!

Please Login or Register  to view this content.

**blue.chio** · 06-15-2013, 09:59 AM

Thank you very much!
(I added that condition but in a wrong place...)

solved!
Best Regards,
blue

IF condition, check more than one cell then Select Case

LinkBack

Thread Tools

Rate This Thread

Display

IF condition, check more than one cell then Select Case

Re: IF condition, check more than one cell then Select Case

Re: IF condition, check more than one cell then Select Case

Re: IF condition, check more than one cell then Select Case

Re: IF condition, check more than one cell then Select Case

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions