Proper syntax for an If statement with OR

**publius190** · 06-26-2012, 09:16 AM

Trying to reference the same row and column as selected cell in Sheet2 and output if it contains certain values:

Please Login or Register  to view this content.

Anyone know what I'm doing wrong here?
I feel like I'm just not understanding some syntax.

**jeffreybrown** · 06-26-2012, 09:18 AM

Try this

Please Login or Register  to view this content.

**snb** · 06-26-2012, 09:42 AM

Please Login or Register  to view this content.

**publius190** · 06-26-2012, 09:45 AM

Originally Posted by jeffreybrown

Try this

Please Login or Register  to view this content.

This was perfect i have a lot of references to do in this vba program and I had no Idea about the with WS statement!

**jeffreybrown** · 06-26-2012, 10:00 AM

Just a way to cut down on repetitive references, but also take a moment to check out what snb has to offer. He really knows how to cut down on the repetitve statements within a procedure.

Glad it worked out for you, thanks for the feedback and marking the thread as solved