looping through a range of cells in excel

Hello Everyone. I just created a macro in excel which looks at a given date, compares that to a row of months and based on a match, moves the cursor underneath the match month. The macro works but I do not know how to do that for a range of cells. I basically want the macro to look at the date in the first row, match it to the months in the following columns (same row), then move to the row beneath it ,do the same thing for the corresponding months in the following columns (same row) and so on till it reaches a blank row. Here is the code which I have created for one cell:

Please Login or Register  to view this content.

I have attached the excel file as well.
I really appreciate anyone who can help me with this.

Thanks
Robby
[email protected]

rbhandair

Welcome to excelforum

Please read forum rules & wrap your VBA code - see links below

There is no attachement with your posting. This site has limits on file types & file sizes that can be attached

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950