Compare Results in an Array

Robb · Mar 6th, 2002, 08:02 AM

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 · Mar 6th, 2002, 10:52 AM

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 · Mar 6th, 2002, 01:09 PM

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.

Mar 6th, 2002, 08:02 AM	#1
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	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! __________________ Thanx.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 10:52 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	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

Mar 6th, 2002, 01:09 PM	#3
Robb Board Regular Join Date: Feb 2002 Location: Winnipeg, Manitoba, CANADA Posts: 130	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.