Transversing through the col.

[SunyIT]

I want to compare a series of numbers stored in a col. on my sheet. How would I transverse through the col. and compare the data in that col. with a number that is stored in my macro?

[Leith Ross]

Hello SunyIT,

Do you want to match a single value or multiple values? Will the macro return a value like true/false, the cell address of the match, or a range of match addresses?

Sincerely,
Leith Ross

[SunyIT]

The overall program is designed to do the following:

Based on the system clock date in the computer I want to create a program that will go through a series of rows that hold information such as Name, dates, address, etc. I want to go through all the rows and compare the date and using and if-Else statement determine which of the following actions I should take, general email, urgent email, or nothing.

Currently I have the month, date, and year stored in three col and three variables. I need to transverse through the sheet like you would transverse an 2 dimensional array in C (ex. array[x][y]). I want to go down the col comparing each individual row. I do not have this is a separate function but I would probably do it as a boolean return if I did so. I am not even sure if this is possible since I cannot seem to find anything online.

Any help would be most appreciated!!

[Leith Ross]

Hello SunyIT,

My cat decided to have her kittens a few hours ago and now I am catching up with my posts. I don't have a good picture in my head of your layout. Can you post an example of your sheet layout? Just a couple of typical name, address, and dates with the rows and columns will be fine.

Sincerely,
Leith Ross

[SunyIT]

A B C D E F G
ContactName Email DateOfPurchase MonthDue DayDue YearDue Amt
SUNYIT Address date 4 10 2008 $45
Ross Address date 5 11 2009 $35

This is just a few of the col that I have however the others are irrelevant in this part of the code. The top row is just headings that will be skipped over in the process of transversing through the columns. I want to compare the month, day, and year information that is in the rows below one right after another to the current time in the system clock which will be stored in variables in the code using the day(), month(), and year() functions that are inherit to the language.

Hope this helps.