Could you not just use =Sheet!A1 in the first sheet and copy down?

--
HTH

Bob Phillips

"Les Wegg" wrote in message
...
I have 2shts, one with old data, one with new (Changes, Adds, Deletes)
The Rows could be as many as 10 columns wide and may not be in any
particular order. I require some code to take the first row in sht.2 and
look for it in sht.1 and tell me if it has changed (C) or is added (A) a
column may be added to depict the Changes, Adds, Deletes.