comparing 2 ranges.....problem

[welchs101]

hi. I am trying to compare 2 ranges using the following code and i can do

Please Login or Register  to view this content.

The ranges are currentlist and newlist. the problem is i have to use "workbooks........................" to actually reference each individual component of the range (see above). Is there another way?

[welchs101]

to access individual elements in a range you use the ".cells"

Please Login or Register  to view this content.