VBA Search to find value in "O" column under the condition that "S" column is blank

**nenadmail** · 08-27-2012, 05:19 AM

Ok so I have this code below:

Please Login or Register  to view this content.

It's almost what I need. Now I just need it to search for another value in another cell of the same row.

It's as if I'm searching for two values in two places at the same time. Something like this....
FIND ONE ROW: Where Range("O8:O5000") = vVal AND where Range("S" of same row) = blank

Thanks!

**patel45** · 08-27-2012, 05:59 AM

Attach please a sample file with comments

**nenadmail** · 08-27-2012, 06:32 AM

heres a sample file.

Searchhh.xlsm

**patel45** · 08-27-2012, 09:33 AM

Please Login or Register  to view this content.

**nenadmail** · 08-27-2012, 10:15 AM

Thanks a lot ...

VBA Search to find value in "O" column under the condition that "S" column is blank

LinkBack

Thread Tools

Rate This Thread

Display

VBA Search to find value in "O" column under the condition that "S" column is blank

Re: Alter Search VBA to look in 2 columns

Re: Alter Search VBA to look in 2 columns

Re: VBA Search to find value in "O" column under the condition that "S" column is blank

Re: VBA Search to find value in "O" column under the condition that "S" column is blank

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions