Value compared to a range of values

**skazis** · 04-06-2011, 07:41 AM

Hello,
I am trying to compare a value to a range of values. I have many to compare to so AND is not an option, writing is too long, unless it is possible to put in an AND many values. And I can't use for loop to do something like Range("H"& integer).Value This is my shortened code that does not work because of the way I write Range syntax there:

Please Login or Register  to view this content.

**watersev** · 04-06-2011, 07:58 AM

hi, skazis, can you post a sample workbook showing your original data and the the result you need to obtain?

**skazis** · 04-06-2011, 08:06 AM

In H column there are only numbers in cells, no blank cells. Like,
H1=5
H2=40
H3=41
...
H100=30

What I need is to ta loop trough X and if a particular X equals to any of these H column values then I skip this this X and continue to next, else I do my code.

**watersev** · 04-06-2011, 08:23 AM

this is one of the ways it can be done:

Please Login or Register  to view this content.

**skazis** · 04-06-2011, 08:34 AM

Thank you very much. Programming takes a lot of imagination, I hope I'll I have it there since it has been only 3 days for me in VBA

**watersev** · 04-06-2011, 09:44 AM

if you are happy with the outcome and the issue is solved please mark the thread as solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes