Compare Results in an Array

[Robb]

I have to compare the values of an array with a another value. How do you add items to an array using VBA Code? For example:

Col A = Start #
Col B = End #

Cell A1 = 100, B1 = 200
Nothing in Row 2
Cell A3 = 300, B3 = 400
Cell A4 = 500, B4 = 600
etc....

Now I want to compare each Start # and End # with my Start # and End #. Any Help would be fabulous!

 

[Damon Ostrander]

Hi Robert,

I don't understand your question, so maybe others are confused as well. Can you provide some clarification?

In particular, your question subject line refers to adding values to an array, but your problem never refers to either "adding" or to an "array". In your example you show a set of start/end times, but these appear to be in cells and not the result of an Excel Array formula, so are you just using the term "array" in a very general sense?

Damon

 

[Robb]

It's OK, I got around the task. Thanks anyways.

All I wanted to do was put a range in an array so that I could loop through each individual number to compare against my number.