Group,
I'll ask this a different way with more detail. I have
For.....Next loop that goes from row 46 to some unknown number les
than 2000. I increment a counter that moves me down the first colum
of the spreadsheet. When a logical condition is met, I compare th
cells (one for one) in that row with the cells on another sheet (on
for one) in the same row. Everything here works fine. The problem I'
having is one of efficiency. The row I'm on can have a variable numbe
of cells with data. I want to find the last cell in the row that ha
data. I want to save this number to a variable. Presently when I'
comparing cells within the row, once I get to the end of the data i
the row, the comparing continues until column 52, at which the proces
begins again. Note that a row can have cells with no data in the
before the last cell with data. Some rows can have 20 plus cells wit
no data in either worksheets cells for the row I'm working in. S
there is 20+ rows of needless comparing. Its probably still clear a
mud, but hopefully I can get something. Oh, BTW, everyone respondin
in this group have been professional and educating. Thank you for al
your assistance.

A budding VBA programmer..........

Ton

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=39166